Revision 3634
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/py_functions.sql | ||
|---|---|---|
| 149 | 149 |
-- |
| 150 | 150 |
|
| 151 | 151 |
CREATE FUNCTION "_dateRangeEnd"(value text) RETURNS text |
| 152 |
LANGUAGE sql IMMUTABLE |
|
| 152 |
LANGUAGE sql IMMUTABLE STRICT
|
|
| 153 | 153 |
AS $_$ |
| 154 | 154 |
SELECT (py_functions.parse_date_range($1))[2] |
| 155 | 155 |
$_$; |
| ... | ... | |
| 162 | 162 |
-- |
| 163 | 163 |
|
| 164 | 164 |
CREATE FUNCTION "_dateRangeStart"(value text) RETURNS text |
| 165 |
LANGUAGE sql IMMUTABLE |
|
| 165 |
LANGUAGE sql IMMUTABLE STRICT
|
|
| 166 | 166 |
AS $_$ |
| 167 | 167 |
SELECT (py_functions.parse_date_range($1))[1] |
| 168 | 168 |
$_$; |
Also available in: Unified diff
schemas/py_functions.sql: _dateRange*(): Made functions STRICT because they return NULL on NULL input