Revision 5956
Added by Aaron Marcuse-Kubitza about 12 years ago
schemas/functions.sql | ||
---|---|---|
47 | 47 |
|
48 | 48 |
|
49 | 49 |
-- |
50 |
-- Name: _and(boolean, boolean); Type: FUNCTION; Schema: functions; Owner: - |
|
50 |
-- Name: _and(boolean, boolean, boolean, boolean, boolean); Type: FUNCTION; Schema: functions; Owner: -
|
|
51 | 51 |
-- |
52 | 52 |
|
53 |
CREATE FUNCTION _and("0" boolean DEFAULT NULL::boolean, "1" boolean DEFAULT NULL::boolean) RETURNS boolean |
|
53 |
CREATE FUNCTION _and("0" boolean DEFAULT NULL::boolean, "1" boolean DEFAULT NULL::boolean, "2" boolean DEFAULT NULL::boolean, "3" boolean DEFAULT NULL::boolean, "4" boolean DEFAULT NULL::boolean) RETURNS boolean
|
|
54 | 54 |
LANGUAGE sql IMMUTABLE |
55 | 55 |
AS $_$ |
56 | 56 |
SELECT bool_and(value) |
... | ... | |
58 | 58 |
(VALUES |
59 | 59 |
($1) |
60 | 60 |
, ($2) |
61 |
, ($3) |
|
62 |
, ($4) |
|
63 |
, ($5) |
|
61 | 64 |
) |
62 | 65 |
AS v (value) |
63 | 66 |
$_$; |
64 | 67 |
|
65 | 68 |
|
66 | 69 |
-- |
67 |
-- Name: FUNCTION _and("0" boolean, "1" boolean); Type: COMMENT; Schema: functions; Owner: - |
|
70 |
-- Name: FUNCTION _and("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean); Type: COMMENT; Schema: functions; Owner: -
|
|
68 | 71 |
-- |
69 | 72 |
|
70 |
COMMENT ON FUNCTION _and("0" boolean, "1" boolean) IS 'NULL values are ignored rather than propagated.'; |
|
73 |
COMMENT ON FUNCTION _and("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean) IS 'NULL values are ignored rather than propagated.';
|
|
71 | 74 |
|
72 | 75 |
|
73 | 76 |
-- |
74 |
-- Name: _and(boolean, boolean, boolean, boolean, boolean); Type: FUNCTION; Schema: functions; Owner: - |
|
75 |
-- |
|
76 |
|
|
77 |
CREATE FUNCTION _and("0" boolean DEFAULT NULL::boolean, "1" boolean DEFAULT NULL::boolean, "2" boolean DEFAULT NULL::boolean, "3" boolean DEFAULT NULL::boolean, "4" boolean DEFAULT NULL::boolean) RETURNS boolean |
|
78 |
LANGUAGE sql IMMUTABLE |
|
79 |
AS $_$ |
|
80 |
SELECT bool_and(value) |
|
81 |
FROM |
|
82 |
(VALUES |
|
83 |
($1) |
|
84 |
, ($2) |
|
85 |
, ($3) |
|
86 |
, ($4) |
|
87 |
, ($5) |
|
88 |
) |
|
89 |
AS v (value) |
|
90 |
$_$; |
|
91 |
|
|
92 |
|
|
93 |
-- |
|
94 | 77 |
-- Name: _eq(anyelement, anyelement); Type: FUNCTION; Schema: functions; Owner: - |
95 | 78 |
-- |
96 | 79 |
|
Also available in: Unified diff
schemas/functions.sql: Removed duplicate previous version of _and() with fewer parameters