The RETURNING Keyword in PostgreSQL

The RETURNING keyword in PostgreSQL gives an opportunity to return from the insert or update statement the values of any columns after the insert or update was run. I mentioned this in passing in a few of my talks that touch on PostgreSQL recently, and it often gets twitter comment so here's a quick example of the RETURNING keyword in PostgreSQL. The newest releases of PostgreSQL are excellent and I'm seeing many teams considering moving their traditional MySQL setups over - this is just one of the extra goodies that you get when you use PostgreSQL! Let's look at an example. Continue reading