Revision 5956
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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