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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers