Re: MySQL LAST_INSERT_ID() to Postgres - Mailing list pgsql-general

From Christophe
Subject Re: MySQL LAST_INSERT_ID() to Postgres
Date
Msg-id 3AC6F20E-8EEA-425B-BD77-66B350FD2C93@thebuild.com
Whole thread Raw
In response to Re: MySQL LAST_INSERT_ID() to Postgres  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Matthew Dennis"
Date:
Subject: Re: indexes on functions and create or replace function
Next
From: Bill
Date:
Subject: Re: MySQL LAST_INSERT_ID() to Postgres