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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

  From Date Subject
Next Message Carol Walter 2009-04-23 17:05:17 Re: currval, lastval, nextvar?
Previous Message Andreas Kretschmer 2009-04-23 16:17:39 Re: currval, lastval, nextvar?