Project

General

Profile

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
';
(12-12/14)