Revision 7289
Added by Aaron Marcuse-Kubitza over 11 years ago
| schemas/functions.sql | ||
|---|---|---|
| 170 | 170 |
CREATE FUNCTION _max("0" anyelement DEFAULT NULL::unknown, "1" anyelement DEFAULT NULL::unknown, "2" anyelement DEFAULT NULL::unknown, "3" anyelement DEFAULT NULL::unknown, "4" anyelement DEFAULT NULL::unknown, "5" anyelement DEFAULT NULL::unknown, "6" anyelement DEFAULT NULL::unknown, "7" anyelement DEFAULT NULL::unknown, "8" anyelement DEFAULT NULL::unknown, "9" anyelement DEFAULT NULL::unknown) RETURNS anyelement
|
| 171 | 171 |
LANGUAGE sql IMMUTABLE |
| 172 | 172 |
AS $_$ |
| 173 |
SELECT GREATEST( |
|
| 174 |
$1 |
|
| 175 |
, $2 |
|
| 176 |
, $3 |
|
| 177 |
, $4 |
|
| 178 |
, $5 |
|
| 179 |
, $6 |
|
| 180 |
, $7 |
|
| 181 |
, $8 |
|
| 182 |
, $9 |
|
| 183 |
, $10 |
|
| 184 |
) |
|
| 173 |
SELECT GREATEST($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) |
|
| 185 | 174 |
$_$; |
| 186 | 175 |
|
| 187 | 176 |
|
| ... | ... | |
| 281 | 270 |
CREATE FUNCTION _min("0" anyelement DEFAULT NULL::unknown, "1" anyelement DEFAULT NULL::unknown, "2" anyelement DEFAULT NULL::unknown, "3" anyelement DEFAULT NULL::unknown, "4" anyelement DEFAULT NULL::unknown, "5" anyelement DEFAULT NULL::unknown, "6" anyelement DEFAULT NULL::unknown, "7" anyelement DEFAULT NULL::unknown, "8" anyelement DEFAULT NULL::unknown, "9" anyelement DEFAULT NULL::unknown) RETURNS anyelement
|
| 282 | 271 |
LANGUAGE sql IMMUTABLE |
| 283 | 272 |
AS $_$ |
| 284 |
SELECT LEAST( |
|
| 285 |
$1 |
|
| 286 |
, $2 |
|
| 287 |
, $3 |
|
| 288 |
, $4 |
|
| 289 |
, $5 |
|
| 290 |
, $6 |
|
| 291 |
, $7 |
|
| 292 |
, $8 |
|
| 293 |
, $9 |
|
| 294 |
, $10 |
|
| 295 |
) |
|
| 273 |
SELECT LEAST($1, $2, $3, $4, $5, $6, $7, $8, $9, $10) |
|
| 296 | 274 |
$_$; |
| 297 | 275 |
|
| 298 | 276 |
|
Also available in: Unified diff
schemas/functions.sql: _max(), _min(): Put $n params all on one line to match other aggregating functions