Revision 4982
Added by Aaron Marcuse-Kubitza about 12 years ago
functions.sql | ||
---|---|---|
16 | 16 |
CREATE SCHEMA functions; |
17 | 17 |
|
18 | 18 |
|
19 |
-- |
|
20 |
-- Name: SCHEMA functions; Type: COMMENT; Schema: -; Owner: - |
|
21 |
-- |
|
22 |
|
|
23 |
COMMENT ON SCHEMA functions IS 'IMPORTANT: Functions must always return NULL in place of '''' (the empty string). This ensures that empty strings do not find their way into VegBIEN.'; |
|
24 |
|
|
25 |
|
|
19 | 26 |
SET search_path = functions, pg_catalog; |
20 | 27 |
|
21 | 28 |
-- |
Also available in: Unified diff
schemas/functions.sql, py_functions.sql: Added schema comment that functions must always return NULL in place of the empty string, to ensure that empty strings do not find their way into VegBIEN. Note that row-based import automatically removes empty strings because the intermediate values are stored in XML and our XML DOM traversing code auto-replaces the empty string with NULL. Column-based import, on the other hand, does not, because the intermediate data is stored in database temp tables instead of a DOM tree.