Revision 4542
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/py_functions.sql | ||
|---|---|---|
| 110 | 110 |
ALTER FUNCTION py_functions."_dateRangeEnd"(value text) OWNER TO bien; |
| 111 | 111 |
|
| 112 | 112 |
-- |
| 113 |
-- Name: _dateRangeEnd(timestamp with time zone); Type: FUNCTION; Schema: py_functions; Owner: bien |
|
| 114 |
-- |
|
| 115 |
|
|
| 116 |
CREATE FUNCTION "_dateRangeEnd"(value timestamp with time zone) RETURNS timestamp with time zone |
|
| 117 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 118 |
AS $_$ |
|
| 119 |
SELECT $1 |
|
| 120 |
$_$; |
|
| 121 |
|
|
| 122 |
|
|
| 123 |
ALTER FUNCTION py_functions."_dateRangeEnd"(value timestamp with time zone) OWNER TO bien; |
|
| 124 |
|
|
| 125 |
-- |
|
| 113 | 126 |
-- Name: _dateRangeStart(text); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 114 | 127 |
-- |
| 115 | 128 |
|
| ... | ... | |
| 123 | 136 |
ALTER FUNCTION py_functions."_dateRangeStart"(value text) OWNER TO bien; |
| 124 | 137 |
|
| 125 | 138 |
-- |
| 139 |
-- Name: _dateRangeStart(timestamp with time zone); Type: FUNCTION; Schema: py_functions; Owner: bien |
|
| 140 |
-- |
|
| 141 |
|
|
| 142 |
CREATE FUNCTION "_dateRangeStart"(value timestamp with time zone) RETURNS timestamp with time zone |
|
| 143 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 144 |
AS $_$ |
|
| 145 |
SELECT $1 |
|
| 146 |
$_$; |
|
| 147 |
|
|
| 148 |
|
|
| 149 |
ALTER FUNCTION py_functions."_dateRangeStart"(value timestamp with time zone) OWNER TO bien; |
|
| 150 |
|
|
| 151 |
-- |
|
| 126 | 152 |
-- Name: _namePart(text, text, text); Type: FUNCTION; Schema: py_functions; Owner: bien |
| 127 | 153 |
-- |
| 128 | 154 |
|
Also available in: Unified diff
schemas/py_functions.sql: Added pass-through _dateRangeStart(timestamp), _dateRangeEnd(timestamp) for datasource date columns that are already timestamps