By now you've read about PostgreSQL 9.5 and our shiny new UPSERT feature .  And you're thinking, "hey, 9.5 is still in alpha, ...

In prior posts, I've gone over some methods to prevent cycles from being added to your database.  However, imagine that someone has hand...

So, this question came up on IRC today: "How can I take a one-week date range, and have each date in a separate column?" This ...

So ... you're using some of 9.4's new advanced aggregates, including FILTER and WITHIN GROUP.  You want to take some statistical sam...

Here's one which just came up:  how to see all of the elements in a new array which were not in the old array.  This isn't currently...