Hi I am looking for some way how to get some ID variable that remains
unchanged and unique throughout a connection, like MS SQL @@SPID. I am
running PostGreSQL 7.2.1 Native Windows Port. I would be thanksfull for
any help.
Thanks a lot
Honza


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Fri, Apr 16, 2004 at 11:09:00 +0200,
Jan Blaha <jan.blaha (AT) terminus (DOT) cz> wrote:
You could use a sequence to provide this. You will need to make an initial
call of nextval at the start of the session and then not call it again
(for the same sequence). Use currval to retrieve the id.

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings