Skip site navigation (1) Skip section navigation (2)

Re: SQL 2003 conformance

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Troels Arvin <troels(at)arvin(dot)dk>
Cc: pgsql-docs(at)postgresql(dot)org
Subject: Re: SQL 2003 conformance
Date: 2004-10-21 16:35:03
Message-ID: 200410210935.03857.josh@agliodbs.com (view raw or flat)
Thread:
Lists: 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

In response to

pgsql-docs by date

Next:From: stig eriksonDate: 2004-10-23 11:30:41
Subject: PostgreSQL 8.0.0beta3 Documentation
Previous:From: Peter EisentrautDate: 2004-10-21 12:20:49
Subject: Re: SQL 2003 conformance

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group