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