Re: How to autoincrement a primary key...

On 23/09/06, Richard Broersma Jr <rabroersma(at)yahoo(dot)com> wrote:
> Is just shorthand notation for:
>
> CREATE SEQUENCE foo START 1;
> CREATE TABLE bar (id integer PRIMARY KEY DEFAULT nextval('bar'));

Doug, just a slight typo correction in that second line Richard gave
you (bar should be foo), it should read in full:

CREATE SEQUENCE foo START 1;
CREATE TABLE bar (id integer PRIMARY KEY DEFAULT nextval('foo'));

Andy

--
name: Andrew Chilton
web: http://kapiti.geek.nz/