Re: SQL:2011 features

On mån, 2012-01-02 at 09:33 +0000, Simon Riggs wrote:
> Are there any features in SQL:2011 that we should be considering for 9.2?
> 
> We seem quite close on temporal stuff, so maybe just a little syntax work?

I am aware of this piece on what's new in SQL:2011:
http://petereisentraut.blogspot.com/2010/04/news-from-sql-standard.html

Based on that:

* ALTER TABLE ... ALTER COLUMN ... SET/DROP NOT NULL: done since PG 7.3

* Constraints set to NO ENFORCE: Apparently no current interest; more
interest in the NOT VALID track at the moment.

* System-versioned tables: Hmm, just a little syntax work? Not sure how
much interest there is.

* Combined data change and retrieval: We decided against supporting the
standard syntax for this.

* Named arguments in function calls: done since PG 9.0; and we're
phasing out the => operator.

* Default values for function arguments: done since PG 9.0