"Kevin Macdonald" <[EMAIL PROTECTED]> writes:
> Now, take these two operations:
> SQL> select currval ('seq')
> returns 11
> SQL> select nextval ('seq'), currval ('seq')
> returns (12, 12)
> I would have expected it to have returned (12, 11).
No, because currval reports the latest nextval res
The following bug has been logged online:
Bug reference: 3240
Logged by: Kevin Macdonald
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3
Operating system: Windows XP
Description:Unexpected evaluation sequence
Details:
Take these two operations:
SQL> sele