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.
> The attached patch will change this behaviour by reading the sequence tuple
> and returning the last_value attribute if nextval has not been called on the
> sequence yet.
This is feature :)
1. This is what Oracle does.
2. currval () is described as returning value returned by
last nextval() in _session_.
Vadim
In response to
pgsql-hackers by date
| Next: | From: Jan Wieck | Date: 1998-03-02 08:02:05 |
| Subject: Re: [HACKERS] Rule plan size for views? |
| Previous: | From: Tom I Helbekkmo | Date: 1998-03-02 06:56:03 |
| Subject: Re: [HACKERS] configure.in patch for --with-tcl |