Project

General

Profile

« Previous | Next » 

Revision 4982

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.

View differences:

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