INSERT Return Value?

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.