Revision 5408
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 201 | 201 |
|
| 202 | 202 |
|
| 203 | 203 |
-- |
| 204 |
-- Name: _max(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
|
| 205 |
-- |
|
| 206 |
|
|
| 207 |
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
|
|
| 208 |
LANGUAGE sql IMMUTABLE |
|
| 209 |
AS $_$ |
|
| 210 |
SELECT max(value) |
|
| 211 |
FROM |
|
| 212 |
(VALUES |
|
| 213 |
($1) |
|
| 214 |
, ($2) |
|
| 215 |
, ($3) |
|
| 216 |
, ($4) |
|
| 217 |
, ($5) |
|
| 218 |
, ($6) |
|
| 219 |
, ($7) |
|
| 220 |
, ($8) |
|
| 221 |
, ($9) |
|
| 222 |
, ($10) |
|
| 223 |
) |
|
| 224 |
AS v (value) |
|
| 225 |
$_$; |
|
| 226 |
|
|
| 227 |
|
|
| 228 |
-- |
|
| 204 | 229 |
-- Name: _merge(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
| 205 | 230 |
-- |
| 206 | 231 |
|
| ... | ... | |
| 240 | 265 |
|
| 241 | 266 |
|
| 242 | 267 |
-- |
| 268 |
-- Name: _min(anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
|
| 269 |
-- |
|
| 270 |
|
|
| 271 |
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
|
|
| 272 |
LANGUAGE sql IMMUTABLE |
|
| 273 |
AS $_$ |
|
| 274 |
SELECT min(value) |
|
| 275 |
FROM |
|
| 276 |
(VALUES |
|
| 277 |
($1) |
|
| 278 |
, ($2) |
|
| 279 |
, ($3) |
|
| 280 |
, ($4) |
|
| 281 |
, ($5) |
|
| 282 |
, ($6) |
|
| 283 |
, ($7) |
|
| 284 |
, ($8) |
|
| 285 |
, ($9) |
|
| 286 |
, ($10) |
|
| 287 |
) |
|
| 288 |
AS v (value) |
|
| 289 |
$_$; |
|
| 290 |
|
|
| 291 |
|
|
| 292 |
-- |
|
| 243 | 293 |
-- Name: _nullIf(anyelement, text, datatype); Type: FUNCTION; Schema: functions; Owner: - |
| 244 | 294 |
-- |
| 245 | 295 |
|
Also available in: Unified diff
schemas/functions.sql: Added _max(), _min()