[DERBY-5216] Add support for GREATEST and LEAST functions

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.8.1.2
• Component/s: SQL
• Labels: derby_triage10_10 function sql
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 03/May/11 13:10
• Updated: 28/Sep/12 04:40

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