Revision 4982
Added by Aaron Marcuse-Kubitza about 12 years ago
py_functions.sql | ||
---|---|---|
18 | 18 |
|
19 | 19 |
ALTER SCHEMA py_functions OWNER TO bien; |
20 | 20 |
|
21 |
-- |
|
22 |
-- Name: SCHEMA py_functions; Type: COMMENT; Schema: -; Owner: bien |
|
23 |
-- |
|
24 |
|
|
25 |
COMMENT ON SCHEMA py_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.'; |
|
26 |
|
|
27 |
|
|
21 | 28 |
SET search_path = py_functions, pg_catalog; |
22 | 29 |
|
23 | 30 |
-- |
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.