Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group