Add least and greatest functions #8085
Description
least(1,2,3,4,5); yields 1
greatest(1,2,3,4,5); yields 5
| foo | bar |
|---|---|
| 1 | 0 |
| 2 | 1 |
| 5 | 4 |
| 6 | 7 |
least(foo,bar,3) as min_ceiling; yields
| min_ceiling |
|---|
| 0 |
| 1 |
| 3 |
| 3 |
greatest(foo,bar,3) as max_floor; yields
| max_floor |
|---|
| 3 |
| 3 |
| 5 |
| 7 |