[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: ITP: Slash, Sourceforge (fwd)



On Fri, Jan 28, 2000 at 06:35:12AM +0000, Oliver Elphick wrote:
> Craig Sanders wrote:
> > i noticed that it uses a couple of auto-increment fields. these can
> > be implemented in postgres using a sequence and a trigger. e.g. to
> > create an auto-incrementing field called 'id' in table 'foo':
>
> ... commands for autoincrementing ...
>
> PostgreSQL can now do autoincrementing with a SERIAL data type, which
> is much simpler:
>
> junk=> create table c (id serial, name text);

cool. i hadn't noticed that yet. thanks for the tip.

craig

--
craig sanders


Reply to: