Troels,
> I believe that PostgreSQL 8 doesn't implement SQL:2003's IDENTITY columns,
You're correct. Mind you, IDENTITY was a mistake, and I'm happy we don't
implement it.
> Sequences are allmost implemented, except PostgreSQL doesn't have the NEXT
> VALUE FOR (uses nextval()). As NEXT VALUE FOR functionality is rather
> important for sequences, one might say that it's important for the syntax
> to be equal here.
Hmmm ... good point. Would be worth bringing up on Hackers as a TODO
suggestion.
--
Josh Berkus
Aglio Database Solutions
San Francisco