Better SQL functions in PostgreSQL v14
by
Laurenz Albe |
07.2022We all know and value SQL functions as a handy shortcut. PostgreSQL v14 has introduced a new, better way to […]
Golden Proportions in PostgreSQL
Learn how PostgreSQL can help with basic calculations regarding golden proportions. Do mathematics in your database development work.
PostgreSQL v12 new feature: optimizer support for functions
by
Laurenz Albe |
05.2019 PostgreSQL commit 74dfe58a5927b22c744b29534e67bfdd203ac028 has added “support functions”. This exciting new functionality that allows the optimizer some insight into functions. […]
Choose plpgsql variable names wisely
Pavel Stehule recently wrote the post "Don't use SQL keywords as PLpgSQL variable names" describing the situation when internal stored […]
PostgreSQL: Sharing data across function calls
Recently I did some PostgreSQL consulting in the Berlin area (Germany) when I stumbled over an interesting request: How can […]
Window function: Why first_value and last_value are not bugs
PostgreSQL can be used for more than just trivial queries. A look into what a window function does: first_value and last_value in PostgreSQL.
