Revision 2723
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 194 | 194 |
|
| 195 | 195 |
|
| 196 | 196 |
-- |
| 197 |
-- Name: growthform(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 198 |
-- |
|
| 199 |
|
|
| 200 |
CREATE FUNCTION growthform(value text) RETURNS growthform |
|
| 201 |
LANGUAGE plpgsql IMMUTABLE STRICT |
|
| 202 |
AS $$ |
|
| 203 |
BEGIN |
|
| 204 |
RETURN value::growthform; |
|
| 205 |
EXCEPTION |
|
| 206 |
WHEN data_exception THEN |
|
| 207 |
RAISE WARNING '%', SQLERRM; |
|
| 208 |
RETURN NULL; |
|
| 209 |
END; |
|
| 210 |
$$; |
|
| 211 |
|
|
| 212 |
|
|
| 213 |
-- |
|
| 214 | 197 |
-- Name: namedplace_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 215 | 198 |
-- |
| 216 | 199 |
|
| ... | ... | |
| 261 | 244 |
|
| 262 | 245 |
|
| 263 | 246 |
-- |
| 264 |
-- Name: placerank(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 265 |
-- |
|
| 266 |
|
|
| 267 |
CREATE FUNCTION placerank(value text) RETURNS placerank |
|
| 268 |
LANGUAGE plpgsql IMMUTABLE STRICT |
|
| 269 |
AS $$ |
|
| 270 |
BEGIN |
|
| 271 |
RETURN value::placerank; |
|
| 272 |
EXCEPTION |
|
| 273 |
WHEN data_exception THEN |
|
| 274 |
RAISE WARNING '%', SQLERRM; |
|
| 275 |
RETURN NULL; |
|
| 276 |
END; |
|
| 277 |
$$; |
|
| 278 |
|
|
| 279 |
|
|
| 280 |
-- |
|
| 281 | 247 |
-- Name: plantname_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 282 | 248 |
-- |
| 283 | 249 |
|
| ... | ... | |
| 328 | 294 |
|
| 329 | 295 |
|
| 330 | 296 |
-- |
| 331 |
-- Name: taxonrank(text); Type: FUNCTION; Schema: public; Owner: - |
|
| 332 |
-- |
|
| 333 |
|
|
| 334 |
CREATE FUNCTION taxonrank(value text) RETURNS taxonrank |
|
| 335 |
LANGUAGE plpgsql IMMUTABLE STRICT |
|
| 336 |
AS $$ |
|
| 337 |
BEGIN |
|
| 338 |
RETURN value::taxonrank; |
|
| 339 |
EXCEPTION |
|
| 340 |
WHEN data_exception THEN |
|
| 341 |
RAISE WARNING '%', SQLERRM; |
|
| 342 |
RETURN NULL; |
|
| 343 |
END; |
|
| 344 |
$$; |
|
| 345 |
|
|
| 346 |
|
|
| 347 |
-- |
|
| 348 | 297 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - |
| 349 | 298 |
-- |
| 350 | 299 |
|
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