Hi Jay,
>I want to insert a row; one of the items in the row is of
>type SERIAL. After I insert the row, I want to know what
>value was assigned to the SERIAL item, call it the f_id.
>
Whenever you create a SERIAL column, Postgresql creates an imlicit
Sequence in the background
(as SERIAL isn´t a real Datatype).
I am not entirely sure about the naming convention of this implicit
sequequence, I think it is like this:
TABBLENAME_COLUMNNAME_seq
So, you can get what you need using the currval function.
So if your table looks like this:
CREATE TABLE test
( first SERIAL );
then you can get the value like this:
SELECT currval('test_first_seq');
Regards, Dani
