|
1
|
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
|
';
|
