Revision 10378
Added by Aaron Marcuse-Kubitza over 11 years ago
| 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
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.