Re: SQL 2003 conformance - Mailing list pgsql-docs

From Josh Berkus
Subject Re: SQL 2003 conformance
Date
Msg-id 200410210935.03857.josh@agliodbs.com
Whole thread Raw
In response to Re: SQL 2003 conformance  (Troels Arvin <troels@arvin.dk>)
List pgsql-docs
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

pgsql-docs by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: SQL 2003 conformance
Next
From: stig erikson
Date:
Subject: PostgreSQL 8.0.0beta3 Documentation