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