Darren Ferguson wrote:
> For some reason unknown to myself if you have not initiated a nextval in
> the same psql command line before calling currval then that is the error
> msg you will get.
Slightly wrong. This is the correct behaviour if you haven't
called NEXTVAL in that session before.
The reason is that the SQL standard defines CURRVAL to be
last value returned by NEXTVAL "in this session".
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
In response to
pgsql-general by date
|Next:||From: Stephan Szabo||Date: 2002-01-31 21:22:33|
|Subject: Re: Function to Pivot data|
|Previous:||From: Syd Alsobrook||Date: 2002-01-31 21:21:25|
|Subject: System commands|