Re: [DOCS] SQL 2003 conformance

2004-10-21 Thread Josh Berkus
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

Re: [DOCS] SQL 2003 conformance

2004-10-21 Thread Peter Eisentraut
Troels Arvin wrote: > An obvious question is how strict to be: Very strict. SQL is a standard, not a guideline. If you can't type in what it says, then it's not supported. We make occasional exceptions in extreme cases. For example, we claim to support aliases in the select list (E051-05), b