Re: [GENERAL] getting the value from nextval('sequencename') - Mailing list pgsql-general

From Vadim Mikheev
Subject Re: [GENERAL] getting the value from nextval('sequencename')
Date
Msg-id 37E71283.1C9F03C6@krs.ru
Whole thread Raw
In response to Re: [GENERAL] getting the value from nextval('sequencename')  (Charles Tassell <ctassell@isn.net>)
List pgsql-general
Charles Tassell wrote:
>
> If you are using transactions (as you probably should be) you can use
  ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> curval to get the last assigned value I believe.  Something like:

You can use currval anytime after nextval is called (at least once)
in current database session.

Vadim

pgsql-general by date:

Previous
From: Charles Tassell
Date:
Subject: Re: [GENERAL] Case sensitivity
Next
From: Steen Suder
Date:
Subject: Can I use BLOB's in PostgreSQL?