Re: currval, lastval, nextvar?

From: Andreas Wenk <a(dot)wenk(at)netzmeister-st-pauli(dot)de>
To: pgsql-novice(at)postgresql(dot)org
Cc: johnf <jfabiani(at)yolo(dot)com>
Subject: Re: currval, lastval, nextvar?
Date: 2009-07-06 18:12:59
Message-ID: 4A523EAB.9000001@netzmeister-st-pauli.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

johnf schrieb:
> On Thursday 23 April 2009 07:24:26 am Carol Walter wrote:
>> Does writing a record that automatically updates a
>> sequence count as calling nextval?
>
> Yes if the data type is serial.
>

don't want to make a big discussion out of it - but serial is not really
a datatype but more an alias ... correct? As I remember correctly it was
not possible to use serial in psql in older versions because of that.
Please correct me if i am wrong ...

Cheers

Andy

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Manoj Easwaran Govindan 2009-07-07 05:04:28 Copying data from one table to another
Previous Message Andreas Wenk 2009-07-06 17:44:42 Re: types