On 17/05/2011 16:26, Carlos Mennens wrote:
> On Tue, May 17, 2011 at 11:22 AM, Jaime Casanova<jaime@2ndquadrant.com> wrote:
>> in postgres is as easy as
>>
>> CREATE TABLE test(
>> id SERIAL PRIMARY KEY);
>>
>> hey! it's even less keystrokes!
>
> I don't understand how this command above is associated with being
> able to auto increment the 'id' column. Sorry I'm still learning a
> lot...
Well, the SERIAL pseudo-type creates the sequence, associates it with
the column, and sets a DEFAULT on the column which executes the
nextval() function on the sequence - all in one fell swoop. Read all
about it here:
http://www.postgresql.org/docs/9.0/static/datatype-numeric.html#DATATYPE-SERIAL
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie