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.
In response to
pgsql-general by date
|Next:||From: Bill||Date: 2008-08-28 22:29:51|
|Subject: Re: MySQL LAST_INSERT_ID() to Postgres|
|Previous:||From: Matthew Dennis||Date: 2008-08-28 22:25:49|
|Subject: Re: indexes on functions and create or replace function|