Re: [SLUG] postgreSQL trigger help

["Graeme Merrall" <graeme@nospam.clubnet.net.au>]

> thanks for the auto_increment suggestion. I didn't get your message until
> the slug digest arrived, so please excuse the late reply.
> Unfortunately, psql gives me a parse error at auto_increment, so I don't
> think it is supported in postgres.
> Is what I am doing currently (as described in my last message) a kludge?
You can use type SERIAL instead. This infers several things incuding the
creation of a sequence, data type and (I think) an index. You might want to
check the docs though.
SERIAL is just a handy way of not havng to muck about with sequences.

Cheers,
 Graeme


--
SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
To unsubscribe send email to slug-request@nospam.slug.org.au with
unsubscribe in the text