1 |
12406
|
aaronmk
|
CREATE OR REPLACE FUNCTION if(cond boolean DEFAULT NULL::boolean, "then" anyelement DEFAULT NULL::unknown, "else" anyelement DEFAULT NULL::unknown)
|
2 |
|
|
RETURNS anyelement AS
|
3 |
|
|
$BODY$
|
4 |
|
|
SELECT util._if($1, $2, $3)
|
5 |
|
|
$BODY$
|
6 |
|
|
LANGUAGE sql IMMUTABLE
|
7 |
|
|
COST 100;
|
8 |
|
|
COMMENT ON FUNCTION if(boolean, anyelement, anyelement) IS '
|
9 |
|
|
wrapper that prevents views from getting dropped when the util schema is reinstalled
|
10 |
|
|
';
|
11 |
|
|
|
12 |
|
|
CREATE OR REPLACE FUNCTION ifnull(value anyelement, null_ anyelement)
|
13 |
|
|
RETURNS anyelement AS
|
14 |
|
|
$BODY$
|
15 |
|
|
SELECT util.ifnull($1, $2)
|
16 |
|
|
$BODY$
|
17 |
|
|
LANGUAGE sql IMMUTABLE
|
18 |
|
|
COST 100;
|
19 |
|
|
COMMENT ON FUNCTION ifnull(anyelement, anyelement) IS '
|
20 |
|
|
wrapper that prevents views from getting dropped when the util schema is reinstalled
|
21 |
|
|
';
|