Mike Fahey wrote:
> Does select @@IDENTITY work with version 8.0.02 ?
>
> IT returns "2" every single time.
@ is the absolute value operator. You probably have a column "identity"
that contains 2 or -2.
> All I want to do is get the last inserted id from a sequence.
Use the currval() function.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/