Revision 12513
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 1455 | 1455 |
-- |
| 1456 | 1456 |
|
| 1457 | 1457 |
CREATE FUNCTION source_by_shortname(shortname text, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS integer |
| 1458 |
LANGUAGE plpgsql |
|
| 1458 |
LANGUAGE plpgsql STABLE
|
|
| 1459 | 1459 |
SET search_path TO pg_temp |
| 1460 | 1460 |
AS $$ |
| 1461 | 1461 |
/* must use LANGUAGE plpgsql because LANGUAGE sql does not support runtime |
Also available in: Unified diff
fix: schemas/vegbien.sql: source_by_shortname(): needs to be declared STABLE so it can be constant-folded and only run once per query. (it had previously been VOLATILE because of constraints imposed on functions that run `SET LOCAL search_path`.)