INSERT Return Value? - Mailing list pgsql-novice

From Greg Lindstrom
Subject INSERT Return Value?
Date
Msg-id 457DC390.5020101@novasyshealth.com
Whole thread Raw
Responses Re: INSERT Return Value?
Re: INSERT Return Value?
List pgsql-novice
Hello-

I am running Postgres 8.08 on a Linux system.  When I insert data into a
table I generate and store a value in the table via a trigger that fires
after the insert.  Is there a way to retrieve the value that I generate
with the trigger?  In this case, I am generating a broker number and
would like to get it back.  One method would be to grab the sequence
number of the record and then make another query, but I feel there is a
more elegant way to get the field.

Thanks for your help,
--greg

--
Greg Lindstrom               501 975.4859 (office)
Programmer                   501 219-4455 (fax)
NovaSys Health               greg.lindstrom@novasyshealth.com
Little Rock, Arkansas

"We are the music makers, and we are the dreamers of dreams."  W.W.




pgsql-novice by date:

Previous
From: "Philippe Salama"
Date:
Subject: Re: delete cascade question
Next
From: Bram Kuijper
Date:
Subject: do not obtain all columns from DBD::Pg