On Aug 28, 2008, at 3:23 PM, D. Dante Lorenso wrote:
I use RETURNING for all my insert and UPDATE statements now. Usually I'll return the primary key for the table, but sometimes I return a column that is created by one of my triggers. It's awesome to be able to do this in one query.
Word. My current pet architecture is to set up Postgres like an application server (the web front end just call PL/pgSQL stuff rather than doing direct SQL), and this makes my life much easier for that.
