Re: selecting the last record from a table

Actually when you insert into a table, PG gives allows you to fetch the
OID it just created...what
language are you using.....

Here is psql(1)'s session

Test1=> insert into test values ('something');
INSERT 36205 1
Test1=>

Doug McNaught wrote:

>MT <mt(at)open2web(dot)com> writes:
>
>
>
>>I have a script that inserts a record into a table and increments the
>>unique field using nextval('my_sequence'). My problem is once I have
>>inserted the record, I'd like to select this same record and display
>>it so that the user knows he has actually inserted the record. I'm
>>wondering if there's a bit of sql to select the last record.
>>
>>
>
>SELECT * FROM mytable WHERE my_unique_field = currval('my_sequence');
>
>-Doug
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org
>
>