Re: can you select on an OID?

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Jay G(dot) Scott" <gl(at)arlut(dot)utexas(dot)edu>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: can you select on an OID?
Date: 2003-04-22 23:20:19
Message-ID: 3EA5CE33.1010408@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Joe Conway 2003-04-22 23:23:26 Re: Select current_timestamp as a different timezone..
Previous Message Williams, Travis L, NPONS 2003-04-22 23:11:50 Select current_timestamp as a different timezone..