getting val of serial field after insert

From: Jim Archer <jim(at)archer(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: getting val of serial field after insert
Date: 1999-07-09 04:51:06
Message-ID: 4.2.0.54.19990709004823.0096fa90@x.archer.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi All...

I have been inserting records into a table using the SQL insert statement
via the perl5 Pg module. One of the field types is serial, and I have been
trying to figure out how to get the value that was assigned in the field as
a result of the insert. The serial typed field is the only one guaranteed
to be unique, so I can't really do a search, and there are several people
adding data at once, so I can't reliable guess. Can anyone help?

Thanks VERY much!!!

Jim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan davis 1999-07-09 07:46:42 Re: [GENERAL] just little BUG
Previous Message MAILER-DAEMON 1999-07-09 04:26:38 Undeliverable Message