Re: simulating INSERT return values with default values of sequences

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: simulating INSERT return values with default values of sequences
Date: 2002-07-22 20:09:19
Message-ID: 20020722160919.P10641@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jul 22, 2002 at 02:18:54PM -0500, Thomas F. O'Connell wrote:
> i didn't see this question asked (or answered in the mailing lists), but
> it seems like it would be an FAQ...

In fact, it _is_ a FAQ, but you didn't know what you needed was
currval(). Here's the entry:

http://www.ca.postgresql.org/docs/faq-english.html#4.15.3

A
--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message James Orr 2002-07-22 20:09:21 Re: Editor for pgsql
Previous Message Jon Lapham 2002-07-22 19:55:02 Re: viewing/altering the "ON DELETE CASCADE" constraint