You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Lukas Eder (JIRA)" <ji...@apache.org> on 2011/05/03 15:11:03 UTC

[jira] [Created] (DERBY-5216) Add support for GREATEST and LEAST functions

Add support for GREATEST and LEAST functions
--------------------------------------------

                 Key: DERBY-5216
                 URL: https://issues.apache.org/jira/browse/DERBY-5216
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.8.1.2
            Reporter: Lukas Eder
            Priority: Minor


A lot of RDMBS support GREATEST and LEAST functions with a variable number of parameters. The underlying RDBMS will then return the greatest/least of n values:

5 = GREATEST(1, 2, 3, 4, 5)
1 = LEAST(1, 2, 3)

I think this would be a nice enhancement for Derby, too

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

[jira] [Updated] (DERBY-5216) Add support for GREATEST and LEAST functions

Posted by "Mamta A. Satoor (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-5216?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mamta A. Satoor updated DERBY-5216:
-----------------------------------

    Labels: derby_triage10_10 function sql  (was: function sql)
    
> Add support for GREATEST and LEAST functions
> --------------------------------------------
>
>                 Key: DERBY-5216
>                 URL: https://issues.apache.org/jira/browse/DERBY-5216
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL
>    Affects Versions: 10.8.1.2
>            Reporter: Lukas Eder
>            Priority: Minor
>              Labels: derby_triage10_10, function, sql
>
> A lot of RDMBS support GREATEST and LEAST functions with a variable number of parameters. The underlying RDBMS will then return the greatest/least of n values:
> 5 = GREATEST(1, 2, 3, 4, 5)
> 1 = LEAST(1, 2, 3)
> I think this would be a nice enhancement for Derby, too

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira