Revision 6437
Added by Aaron Marcuse-Kubitza almost 12 years ago
| functions.sql | ||
|---|---|---|
| 69 | 69 |
-- Name: FUNCTION _and("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean); Type: COMMENT; Schema: functions; Owner: -
|
| 70 | 70 |
-- |
| 71 | 71 |
|
| 72 |
COMMENT ON FUNCTION _and("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean) IS 'NULL values are ignored rather than propagated.';
|
|
| 72 |
COMMENT ON FUNCTION _and("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean) IS '_and() ignores NULL values, while AND combines them with the other values to potentially convert true to NULL. AND should be used with required fields, and _and() with optional fields.';
|
|
| 73 | 73 |
|
| 74 | 74 |
|
| 75 | 75 |
-- |
| ... | ... | |
| 360 | 360 |
|
| 361 | 361 |
|
| 362 | 362 |
-- |
| 363 |
-- Name: FUNCTION _or("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean); Type: COMMENT; Schema: functions; Owner: -
|
|
| 364 |
-- |
|
| 365 |
|
|
| 366 |
COMMENT ON FUNCTION _or("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean) IS '_or() ignores NULL values, while OR combines them with the other values to potentially convert false to NULL. OR should be used with required fields, and _or() with optional fields.';
|
|
| 367 |
|
|
| 368 |
|
|
| 369 |
-- |
|
| 363 | 370 |
-- Name: join_strs_transform(text, text, text); Type: FUNCTION; Schema: functions; Owner: - |
| 364 | 371 |
-- |
| 365 | 372 |
|
Also available in: Unified diff
schemas/functions.sql, vegbien.sql: _and(), _or(): Added comment comparing the function and the corresponding logical operator