PostgreSQL - Get the serial ID of a newly created record
When you assign an Id to an inserted record things are great! When PostgreSQL assigns the Id, things get a little complex, especially if you want to immediately...
Postgres - Creating Store Procedure
Before we look at creating a store procedure, it should be mentioned that debugging these can be a real pain, so try and avoid making them overly complicated....
Postgres - Return result set as JSON
This indispensable library has brought me a great deal of joy when it comes to json-ifying objects and primitives.