postgresql

Long before Python became the go-to scripting language for data processing, Perl was the workhorse language for text…

Of all the alternative procedural languages available in PostgreSQL, PL/Python is the one I reach for most often…

If I had to pick one skill that separates someone who merely queries PostgreSQL from someone who actually…

One of the features that consistently surprises people who are new to PostgreSQL is that operators like +,…

SUM(), AVG(), COUNT(), and ARRAY_AGG() cover a huge percentage of everyday aggregation needs, but sooner or later I…

Triggers are one of those PostgreSQL features I underestimated for a long time — until I inherited a…

For a long time, PostgreSQL only had functions — no true stored procedures — which meant every piece…

User-defined functions are, in my experience, the single most-used piece of PostgreSQL’s extensibility toolkit — far more common…

If you’ve spent any real time working with PostgreSQL, you’ve probably noticed it’s not just another relational database…

Anyone who’s worked with a general-purpose programming language is familiar with the idea of a struct or an…