Re: Support for RETURNING xxx INTO yyy for INSERT and UPDATE?

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: John Napiorkowski <jjn1056(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Support for RETURNING xxx INTO yyy for INSERT and UPDATE?
Date: 2005-02-23 08:59:58
Message-ID: 20050223085958.GA23961@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Tue, Feb 22, 2005 at 10:11:24PM -0800, John Napiorkowski wrote:

> what methods can I use to reliable and efficiently return new
> primary keys from inserts?

See "How do I get the value of a SERIAL insert?" in the FAQ:

http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.11.2

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Mester József 2005-02-23 10:27:15 Can Clipper connect Postgresql
Previous Message Michael Fuhr 2005-02-23 08:18:16 Re: Copy can't parse a float?