Re: currval() in insert statements - Mailing list pgsql-general

From Onno Molenkamp
Subject Re: currval() in insert statements
Date
Msg-id 200902141450.22635.onno@flox.org
Whole thread Raw
In response to Re: currval() in insert statements  (Grzegorz Jaśkiewicz <gryzman@gmail.com>)
List pgsql-general
Hi,

I know that, and nextval -is- being called because it's the default value of
column "a". The problem is that apparently the order in which it's called has
changed for the form with a select, not that I don't know the difference
between currval and nextval.

Onno

Op Saturday 14 February 2009 14:41:44 schreef Grzegorz Jaśkiewicz:
> nextval.
> currval only has value, when sequence wwas used in the session before,
> you would use it to obtain last value returened by nextval. read the
> manual .


Attachment

pgsql-general by date:

Previous
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: currval() in insert statements
Next
From: Oleg Bartunov
Date:
Subject: Re: select max from subquery