Revision 2522
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 254 | 254 |
|
| 255 | 255 |
|
| 256 | 256 |
-- |
| 257 |
-- Name: growthform(unknown); Type: FUNCTION; Schema: public; Owner: - |
|
| 258 |
-- |
|
| 259 |
|
|
| 260 |
CREATE FUNCTION growthform(value unknown) RETURNS growthform |
|
| 261 |
LANGUAGE plpgsql IMMUTABLE |
|
| 262 |
AS $$ |
|
| 263 |
BEGIN |
|
| 264 |
BEGIN |
|
| 265 |
RETURN value; |
|
| 266 |
EXCEPTION |
|
| 267 |
WHEN data_exception THEN |
|
| 268 |
RAISE WARNING '%', SQLERRM; |
|
| 269 |
RETURN NULL; |
|
| 270 |
END; |
|
| 271 |
RETURN new; |
|
| 272 |
END; |
|
| 273 |
$$; |
|
| 274 |
|
|
| 275 |
|
|
| 276 |
-- |
|
| 257 | 277 |
-- Name: namedplace_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 258 | 278 |
-- |
| 259 | 279 |
|
| ... | ... | |
| 304 | 324 |
|
| 305 | 325 |
|
| 306 | 326 |
-- |
| 327 |
-- Name: placerank(unknown); Type: FUNCTION; Schema: public; Owner: - |
|
| 328 |
-- |
|
| 329 |
|
|
| 330 |
CREATE FUNCTION placerank(value unknown) RETURNS placerank |
|
| 331 |
LANGUAGE plpgsql IMMUTABLE |
|
| 332 |
AS $$ |
|
| 333 |
BEGIN |
|
| 334 |
BEGIN |
|
| 335 |
RETURN value; |
|
| 336 |
EXCEPTION |
|
| 337 |
WHEN data_exception THEN |
|
| 338 |
RAISE WARNING '%', SQLERRM; |
|
| 339 |
RETURN NULL; |
|
| 340 |
END; |
|
| 341 |
RETURN new; |
|
| 342 |
END; |
|
| 343 |
$$; |
|
| 344 |
|
|
| 345 |
|
|
| 346 |
-- |
|
| 307 | 347 |
-- Name: plantname_update_ancestors(); Type: FUNCTION; Schema: public; Owner: - |
| 308 | 348 |
-- |
| 309 | 349 |
|
| ... | ... | |
| 354 | 394 |
|
| 355 | 395 |
|
| 356 | 396 |
-- |
| 397 |
-- Name: taxonrank(unknown); Type: FUNCTION; Schema: public; Owner: - |
|
| 398 |
-- |
|
| 399 |
|
|
| 400 |
CREATE FUNCTION taxonrank(value unknown) RETURNS taxonrank |
|
| 401 |
LANGUAGE plpgsql IMMUTABLE |
|
| 402 |
AS $$ |
|
| 403 |
BEGIN |
|
| 404 |
BEGIN |
|
| 405 |
RETURN value; |
|
| 406 |
EXCEPTION |
|
| 407 |
WHEN data_exception THEN |
|
| 408 |
RAISE WARNING '%', SQLERRM; |
|
| 409 |
RETURN NULL; |
|
| 410 |
END; |
|
| 411 |
RETURN new; |
|
| 412 |
END; |
|
| 413 |
$$; |
|
| 414 |
|
|
| 415 |
|
|
| 416 |
-- |
|
| 357 | 417 |
-- Name: concat(text); Type: AGGREGATE; Schema: public; Owner: - |
| 358 | 418 |
-- |
| 359 | 419 |
|
Also available in: Unified diff
schemas/vegbien.sql: Added cast functions for enum types which map invalid values to NULL