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:

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