Revision 2723
Added by Aaron Marcuse-Kubitza over 12 years ago
| functions.sql | ||
|---|---|---|
| 128 | 128 |
|
| 129 | 129 |
|
| 130 | 130 |
-- |
| 131 |
-- Name: boolean(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 132 |
-- |
|
| 133 |
|
|
| 134 |
CREATE FUNCTION "boolean"(value text) RETURNS boolean |
|
| 135 |
LANGUAGE plpgsql IMMUTABLE STRICT |
|
| 136 |
AS $$ |
|
| 137 |
BEGIN |
|
| 138 |
RETURN value::boolean; |
|
| 139 |
EXCEPTION |
|
| 140 |
WHEN data_exception THEN |
|
| 141 |
RAISE WARNING '%', SQLERRM; |
|
| 142 |
RETURN NULL; |
|
| 143 |
END; |
|
| 144 |
$$; |
|
| 145 |
|
|
| 146 |
|
|
| 147 |
-- |
|
| 148 |
-- Name: double precision(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 149 |
-- |
|
| 150 |
|
|
| 151 |
CREATE FUNCTION "double precision"(value text) RETURNS double precision |
|
| 152 |
LANGUAGE plpgsql IMMUTABLE STRICT |
|
| 153 |
AS $$ |
|
| 154 |
BEGIN |
|
| 155 |
RETURN value::double precision; |
|
| 156 |
EXCEPTION |
|
| 157 |
WHEN data_exception THEN |
|
| 158 |
RAISE WARNING '%', SQLERRM; |
|
| 159 |
RETURN NULL; |
|
| 160 |
END; |
|
| 161 |
$$; |
|
| 162 |
|
|
| 163 |
|
|
| 164 |
-- |
|
| 165 | 131 |
-- Name: ensure_not_null(text); Type: FUNCTION; Schema: functions; Owner: - |
| 166 | 132 |
-- |
| 167 | 133 |
|
| ... | ... | |
| 188 | 154 |
|
| 189 | 155 |
|
| 190 | 156 |
-- |
| 191 |
-- Name: timestamp with time zone(text); Type: FUNCTION; Schema: functions; Owner: - |
|
| 192 |
-- |
|
| 193 |
|
|
| 194 |
CREATE FUNCTION "timestamp with time zone"(value text) RETURNS timestamp with time zone |
|
| 195 |
LANGUAGE plpgsql IMMUTABLE STRICT |
|
| 196 |
AS $$ |
|
| 197 |
BEGIN |
|
| 198 |
RETURN value::timestamp with time zone; |
|
| 199 |
EXCEPTION |
|
| 200 |
WHEN data_exception THEN |
|
| 201 |
RAISE WARNING '%', SQLERRM; |
|
| 202 |
RETURN NULL; |
|
| 203 |
END; |
|
| 204 |
$$; |
|
| 205 |
|
|
| 206 |
|
|
| 207 |
-- |
|
| 208 | 157 |
-- Name: join_strs(text, text); Type: AGGREGATE; Schema: functions; Owner: - |
| 209 | 158 |
-- |
| 210 | 159 |
|
Also available in: Unified diff
schemas/functions.sql, vegbien.sql: Removed no longer needed cast functions, which are now created on the fly by column-based import