Re: getting back autonumber just inserted

you have to use currval inside a transaction...

begin;
insert something that increments the counter;
select currval('sequence_name');
end;

using currval inside a transaction guarantees that the
value is correct for your insert statement and has not
changed by another insert statement.

Ted

--- mail TechEvolution <mail(at)techevolution(dot)be> wrote:

> hello
>
> i ame a newbie to PostGreSQL, I ame using PostGreSQL
> 8.0
> (windowsinstaller) on a xp prof platform
>
> i would like to get back the autonumber from the
> last record inserted,
> for other SQL db (m$ sql db ...) i could use:
> SELECT @@ IDENTITY
>
> can someone help me by informing me what the SQL
> syntax is to be used
> with PostGreSQL db and get the same result, the last
> autonumber inserted?
>
> greeTz
>
> wes
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

____________________________________________________
Sell on Yahoo! Auctions – no fees. Bid on great items.
http://auctions.yahoo.com/