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

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 (view raw or flat)
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

pgsql-novice by date

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

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