Re: [BUGS] BUG #3240: Unexpected evaluation sequence

2007-04-19 Thread Tom Lane
"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

[BUGS] BUG #3240: Unexpected evaluation sequence

2007-04-19 Thread Kevin Macdonald
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