On Thu, Jan 11, 2001 at 07:09:08PM -0800, some SMTP stream spewed forth:
> Hi--
>
> Some of you guys suggested to use the 'SERIAL' type for a field that needs
> to be AUTOMATICALLY INCREASED BY 1 by PGSQL without user intervention, but
> it doesn't seem to work. What am I doing wrong?
I know obviously not what query you are using, but here is an example:
create table example (col1 serial col2 <whatever>);
insert into example (col2) values ('whatever');
select * from example;
example
col1 | col2
-----+------------
1 | whatever
The initial value of a serial column is "1".
gh
>
> Julio Cuz, Jr.
> Riverside Community College
> jcuz@rccd.cc.ca.us
>