Skip site navigation (1) Skip section navigation (2)

Re: currval, lastval, nextvar?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: currval, lastval, nextvar?
Date: 2009-04-23 16:21:33
Message-ID: 29148.1240503693@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-novice
Andreas Kretschmer <akretschmer(at)spamfence(dot)net> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> So if you do an insert that doesn't provide a value for that column,
>> the nextval is done implicitly.

> Right, i know.

I know *you* know, Andreas, but this is the -novice list and I figured
a bit more explanation wouldn't be a bad thing.  There isn't actually
any hidden magic in this, if you know where to look, but newbies
probably don't know where to look.

			regards, tom lane

In response to

pgsql-novice by date

Next:From: Carol WalterDate: 2009-04-23 17:05:17
Subject: Re: currval, lastval, nextvar?
Previous:From: Andreas KretschmerDate: 2009-04-23 16:17:39
Subject: Re: currval, lastval, nextvar?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group