| From: | Vadim Mikheev <vadim(at)krs(dot)ru> |
|---|---|
| To: | "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com> |
| Cc: | James Oden <joden(at)Lee(dot)k12(dot)nc(dot)us>, dustin sallings <dustin(at)spy(dot)net>, Fran Fabrizio <fran(at)primary(dot)net>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | Re: [GENERAL] getting the currval of a sequence |
| Date: | 1998-08-15 15:13:14 |
| Message-ID: | 35D5A58A.FDB222E9@krs.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jackson, DeJuan wrote:
>
> I think you should just go with what Vadim suggested and use:
> select currval('my_sequence');
> This will be the same within a transaction, even if there is another
^^^^^^^^^^^
session
> transaction using the same sequence.
> But (if memory servers), you have to have had select a nextval from that
> same sequence within the transaction.
^^^^^^^^^^^
session!
This is from create_sequence manual:
"...Function currval ('sequence_name') may be used
to determine number returned by last call to nextval for
specified sequence in current session."
Vadim
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Schoessow | 1998-08-16 07:02:23 | Delphi 3 and Postgres |
| Previous Message | Peter T Mount | 1998-08-15 10:47:46 | Re: [INTERFACES] No DB connection in Netscape ? Please help. |