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

AW: [HACKERS] sequence creation

From: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
To: "'lockhart(at)alumni(dot)caltech(dot)edu'" <lockhart(at)alumni(dot)caltech(dot)edu>
Cc: PostgreSQL-development <hackers(at)postgreSQL(dot)org>
Subject: AW: [HACKERS] sequence creation
Date: 1998-08-19 09:00:25
Message-ID: 01BDCB61.4EE5EF40@zeugswettera.user.lan.at (view raw or flat)
Thread:
Lists: pgsql-hackers
>> Right now, we allow PRIMARY to auto-create an index.
>> Can we have something to auto-create sequences, instead of the more
>> complicated CREATE SEQUENCE process.
>> Perhaps use the data type SERIAL to autocreate a sequence.  Should 
>> make life easier for novices.  We are getting too many sequence 
>> questions.
>
>That would be possible. I'd be happier doing it for v6.5, since I'm
>hoping to work on docs in the meantime. Of course, maybe it would be
>easy :)
>
>What should the syntax be exactly?
>
>  CREATE TABLE t (s SERIAL);
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

exactly this. :-)    (like in Informix)

Informix also allows to specify a starting value like:
create table t (s serial(1000)); 
defaulting to 1 but I think this additional syntax is rather misleading

Andreas


Responses

pgsql-hackers by date

Next:From: Maarten BoekholdDate: 1998-08-19 09:14:15
Subject: Re: [HACKERS] What does "cannot extend" mean?
Previous:From: Dr. Michael MeskesDate: 1998-08-19 08:27:42
Subject: initb won't work

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