Revision 11667
Added by Aaron Marcuse-Kubitza about 11 years ago
| py_util.sql | ||
|---|---|---|
| 3 | 3 |
-- |
| 4 | 4 |
|
| 5 | 5 |
SET statement_timeout = 0; |
| 6 |
SET lock_timeout = 0; |
|
| 6 | 7 |
SET client_encoding = 'UTF8'; |
| 7 | 8 |
SET standard_conforming_strings = on; |
| 8 | 9 |
SET check_function_bodies = false; |
| ... | ... | |
| 40 | 41 |
ALTER FUNCTION py_util._date(date timestamp with time zone) OWNER TO bien; |
| 41 | 42 |
|
| 42 | 43 |
-- |
| 44 |
-- Name: _date(integer, integer, integer); Type: FUNCTION; Schema: py_util; Owner: bien |
|
| 45 |
-- |
|
| 46 |
|
|
| 47 |
CREATE FUNCTION _date(year integer DEFAULT NULL::integer, month integer DEFAULT NULL::integer, day integer DEFAULT NULL::integer) RETURNS text |
|
| 48 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 49 |
AS $_$ |
|
| 50 |
SELECT py_util._date($1::text, $2::text, $3::text) |
|
| 51 |
$_$; |
|
| 52 |
|
|
| 53 |
|
|
| 54 |
ALTER FUNCTION py_util._date(year integer, month integer, day integer) OWNER TO bien; |
|
| 55 |
|
|
| 56 |
-- |
|
| 43 | 57 |
-- Name: _date(text, text, text); Type: FUNCTION; Schema: py_util; Owner: bien |
| 44 | 58 |
-- |
| 45 | 59 |
|
| ... | ... | |
| 84 | 98 |
ALTER FUNCTION py_util._date(year text, month text, day text) OWNER TO bien; |
| 85 | 99 |
|
| 86 | 100 |
-- |
| 87 |
-- Name: _date(integer, integer, integer); Type: FUNCTION; Schema: py_util; Owner: bien |
|
| 88 |
-- |
|
| 89 |
|
|
| 90 |
CREATE FUNCTION _date(year integer DEFAULT NULL::integer, month integer DEFAULT NULL::integer, day integer DEFAULT NULL::integer) RETURNS text |
|
| 91 |
LANGUAGE sql IMMUTABLE STRICT |
|
| 92 |
AS $_$ |
|
| 93 |
SELECT py_util._date($1::text, $2::text, $3::text) |
|
| 94 |
$_$; |
|
| 95 |
|
|
| 96 |
|
|
| 97 |
ALTER FUNCTION py_util._date(year integer, month integer, day integer) OWNER TO bien; |
|
| 98 |
|
|
| 99 |
-- |
|
| 100 | 101 |
-- Name: _dateRangeEnd(text); Type: FUNCTION; Schema: py_util; Owner: bien |
| 101 | 102 |
-- |
| 102 | 103 |
|
Also available in: Unified diff
schemas/*.sql: updated for PostgreSQL 9.3. this reorders some functions, adds empty comment headers for omitted SEQUENCE SET commands, and (best of all) finally splits view columns onto multiple lines, so that changes in the columns are actually legible (and produce their own svn diff!)