Postgres Pro
Downloads
Home   >   mailing lists

Re: can you select on an OID? - Mailing list pgsql-novice

From Joe Conway
Subject Re: can you select on an OID?
Date
Msg-id 3EA5CE33.1010408@joeconway.com
Whole thread Raw
In response to can you select on an OID?  ("Jay G. Scott" <gl@arlut.utexas.edu>)
List pgsql-novice
Tree view 
Jay G. Scott wrote:
> 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.

See currval() here:
http://www.us.postgresql.org/users-lounge/docs/7.3/postgres/functions-sequence.html

Joe

pgsql-novice by date:

Previous
From: "Williams, Travis L, NPONS"
Date:
Subject: Select current_timestamp as a different timezone..
Next
From: Joe Conway
Date:
Subject: Re: Select current_timestamp as a different timezone..