Re: currval() in insert statements

From: Onno Molenkamp <onno(at)flox(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: currval() in insert statements
Date: 2009-02-14 13:50:22
Message-ID: 200902141450.22635.onno@flox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 .

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oleg Bartunov 2009-02-14 15:41:19 Re: select max from subquery
Previous Message Grzegorz Jaśkiewicz 2009-02-14 13:41:44 Re: currval() in insert statements