1 |
12922
|
aaronmk
|
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 |
13137
|
aaronmk
|
|
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 |
|
|
';
|