Revision 2554
Added by Aaron Marcuse-Kubitza about 12 years ago
| vegbien.sql | ||
|---|---|---|
| 198 | 198 |
-- |
| 199 | 199 |
|
| 200 | 200 |
CREATE FUNCTION growthform(value text) RETURNS growthform |
| 201 |
LANGUAGE plpgsql IMMUTABLE |
|
| 201 |
LANGUAGE plpgsql IMMUTABLE STRICT
|
|
| 202 | 202 |
AS $$ |
| 203 | 203 |
BEGIN |
| 204 | 204 |
BEGIN |
| ... | ... | |
| 268 | 268 |
-- |
| 269 | 269 |
|
| 270 | 270 |
CREATE FUNCTION placerank(value text) RETURNS placerank |
| 271 |
LANGUAGE plpgsql IMMUTABLE |
|
| 271 |
LANGUAGE plpgsql IMMUTABLE STRICT
|
|
| 272 | 272 |
AS $$ |
| 273 | 273 |
BEGIN |
| 274 | 274 |
BEGIN |
| ... | ... | |
| 338 | 338 |
-- |
| 339 | 339 |
|
| 340 | 340 |
CREATE FUNCTION taxonrank(value text) RETURNS taxonrank |
| 341 |
LANGUAGE plpgsql IMMUTABLE |
|
| 341 |
LANGUAGE plpgsql IMMUTABLE STRICT
|
|
| 342 | 342 |
AS $$ |
| 343 | 343 |
BEGIN |
| 344 | 344 |
BEGIN |
Also available in: Unified diff
schemas/vegbien.sql, functions.sql: Made cast functions STRICT to enable the RETURNS NULL ON NULL INPUT optimization