FAQ

[PostgreSQL-Hackers] SQL:2011 features

Simon Riggs
Jan 2, 2012 at 9:33 am
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?

Not sure and not planning anything myself, just checking.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services
reply

Search Discussions

5 responses

  • Peter Eisentraut at Jan 2, 2012 at 6:47 pm

    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
  • Simon Riggs at Jan 2, 2012 at 7:11 pm

    On Mon, Jan 2, 2012 at 6:47 PM, Peter Eisentraut wrote:
    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
    I saw this as well, which seems quite different:

    http://metadata-standards.org/Document-library/Documents-by-number/WG2-N1501-N1550/WG2_N1536_koa046-Temporal-features-in-SQL-standard.pdf

    --
     Simon Riggs                   http://www.2ndQuadrant.com/
     PostgreSQL Development, 24x7 Support, Training & Services
  • Pavel Stehule at Jan 2, 2012 at 8:06 pm
    Hello

    2012/1/2 Peter Eisentraut <peter_e@gmx.net>:
    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?
    trim_array can be simply implemented for one dim array. I am not sure
    about semantic for multidim arrays.

    Regards

    Pavel
  • David E. Wheeler at Jan 2, 2012 at 11:58 pm

    On Jan 2, 2012, at 10:47 AM, Peter Eisentraut wrote:

    * Named arguments in function calls: done since PG 9.0; and we're
    phasing out the => operator.
    We don’t support `=>` for params yet, right? Still just `:=`?

    David
  • Temporalcraig at Jan 3, 2012 at 1:11 pm
    I assume you guys know where to go to get the complete sql:2011 spec:

    http://www.iso.org/iso/search.htm?qt=9075&searchSubmit=Search&sort=rel&type=simple&published=true

    But if time/money is an issue the following seems to be the best publicly
    available description of the temporal features:

    http://metadata-standards.org/Document-library/Documents-by-number/WG2-N1501-N1550/WG2_N1536_koa046-Temporal-features-in-SQL-standard.pdf

    If/as you all make progress with this we would love to hear about it in the
    "Temporal Data" group on LinkedIn, where we are discussing temporal data in
    general and the SQL:2011 extensions in particular.

    http://www.linkedin.com/groups?home=&gid=3885228

    We have had some excellent input from Jeff Davis in the past.

    Craig

    --
    View this message in context: http://postgresql.1045698.n5.nabble.com/SQL-2011-features-tp5114317p5116875.html
    Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

Related Discussions