Revision 6437
Added by Aaron Marcuse-Kubitza almost 12 years ago
| schemas/vegbien.my.sql | ||
|---|---|---|
| 242 | 242 |
|
| 243 | 243 |
|
| 244 | 244 |
-- |
| 245 |
-- Name: FUNCTION _or(`0` int(1), `1` int(1), `2` int(1), `3` int(1), `4` int(1)); Type: COMMENT; Schema: public; Owner: - |
|
| 246 |
-- |
|
| 247 |
|
|
| 248 |
|
|
| 249 |
|
|
| 250 |
|
|
| 251 |
-- |
|
| 245 | 252 |
-- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 246 | 253 |
-- |
| 247 | 254 |
|
| schemas/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 |
|
| schemas/vegbien.sql | ||
|---|---|---|
| 527 | 527 |
|
| 528 | 528 |
|
| 529 | 529 |
-- |
| 530 |
-- Name: FUNCTION _or("0" boolean, "1" boolean, "2" boolean, "3" boolean, "4" boolean); Type: COMMENT; Schema: public; Owner: -
|
|
| 531 |
-- |
|
| 532 |
|
|
| 533 |
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.';
|
|
| 534 |
|
|
| 535 |
|
|
| 536 |
-- |
|
| 530 | 537 |
-- Name: _percent_to_fraction(double precision); Type: FUNCTION; Schema: public; Owner: - |
| 531 | 538 |
-- |
| 532 | 539 |
|
Also available in: Unified diff
schemas/functions.sql, vegbien.sql: _and(), _or(): Added comment comparing the function and the corresponding logical operator