Fun With SQL: Functions in Postgres

In our previous Fun with SQL post on the Citus Data blog, we covered window functions. Window functions are a special class of function that allow you to grab values across rows and then perform some logic. By jumping ahead to window functions, we missed so many of the other handy functions that exist within Postgres natively. There are, in fact, several hundred built-in functions, and when needed, you can also create your own user defined functions (UDFs) if you n…
DZone Database Zone

Sharing is caring!

Pavlos Papadopoulos

TechNews

TheLatestTechNews is a personal news blog that is covering Latest Technology News, Computers, Smartphones, Cameras, Digital Marketing, SEO Tips & Tricks

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

shares