Horton
Menu

Re: [HACKERS] Re: [PATCHES] Changes to sequence.c

bill.allie@mug.org

View thread
From: "Billy G. Allie" <Bill.Allie@mug.org>
To: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Cc: pgsql-patches@postgreSQL.org, pgsql-hackers@postgreSQL.org
Date: 1998-03-06T03:44:31Z
Lists: pgsql-hackers 
Vadim B. Mikheev wrote:
>Billy G. Allie wrote:
>> 
>> I encountered a problem (bug? feature?) where "select currval('sequence')"
>> will generate an error if "select nextval('sequence')" is not executed 
first.
> 
>This is feature :)
>1. This is what Oracle does.
>2. currval () is described as returning value returned by
>   last nextval() in _session_.
> 
>Vadim
> 
Does this mean we should not modify this behavior because "this is what Oracle 
does"?  I can envision where using currval() before nextval() can be useful.

-- 
____       | Billy G. Allie    | Domain....: Bill.Allie@mug.org
|  /|      | 7436 Hartwell     | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie@email.msn.com
|/  |LLIE  | (313) 582-1540    |