Project

General

Profile

« Previous | Next » 

Revision 10378

schemas/util.sql: schema comment: added note that IMMUTABLE SQL-language functions should never be declared STRICT, because this prevents them from being inlined. inlining can create a significant speed improvement (7x+), by avoiding function calls and enabling additional constant folding.

View differences:

schemas/util.sql
19 19
-- Name: SCHEMA util; Type: COMMENT; Schema: -; Owner: -
20 20
--
21 21

  
22
COMMENT ON SCHEMA util 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.';
22
COMMENT ON SCHEMA util 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.
23 23

  
24
NOTE: IMMUTABLE SQL-language functions should never be declared STRICT, because this prevents them from being inlined. inlining can create a significant speed improvement (7x+), by avoiding function calls and enabling additional constant folding.';
24 25

  
26

  
25 27
SET search_path = util, pg_catalog;
26 28

  
27 29
--

Also available in: Unified diff