search

josefmezera / h2database

Automatically exported from code.google.com/p/h2database
0 stars 0 forks source link

Add support for SQL standard ordered set functions #564

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
The SQL standard supports ordered set functions, i.e. hypothetical set 
functions and inverse distribution functions.

It would be interesting to support those also in H2:

<ordered set function> ::=
    <hypothetical set function>
  | <inverse distribution function>

<hypothetical set function> ::=
    <rank function type> <left paren>
        <hypothetical set function value expression list> <right paren>
    <within group specification>

<within group specification> ::=
    WITHIN GROUP <left paren> ORDER BY <sort specification list> <right paren>

<inverse distribution function> ::=
    <inverse distribution function type> <left paren>
        <inverse distribution function argument> <right paren>
    <within group specification>

More details in this discussion:
https://groups.google.com/forum/#!topic/h2-database/q05LJcToXBA

Original issue reported on code.google.com by lukas.eder@gmail.com on 5 Jun 2014 at 5:10