Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-5216

Add support for GREATEST and LEAST functions

Attach filesAttach ScreenshotAdd voteVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Open
    • Minor
    • Resolution: Unresolved
    • 10.8.1.2
    • None
    • SQL
    • Normal

    Description

      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

      Attachments

        Activity
          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            lukas.eder Lukas Eder
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Slack

                Issue deployment