Revision 12315
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 1464 | 1464 |
/* function option search_path is needed to limit the effects of |
| 1465 | 1465 |
`SET LOCAL search_path` (mk_set_search_path()) to the current function */ |
| 1466 | 1466 |
DECLARE |
| 1467 |
source_id integer; |
|
| 1467 |
source_id_ integer;
|
|
| 1468 | 1468 |
shortname_ text = shortname; |
| 1469 | 1469 |
BEGIN |
| 1470 | 1470 |
EXECUTE util.mk_use_own_schema(schema_anchor); |
| 1471 | 1471 |
|
| 1472 |
SELECT source_id INTO source_id |
|
| 1473 |
FROM source WHERE shortname = shortname_ LIMIT 1 |
|
| 1472 |
SELECT source_id INTO source_id_
|
|
| 1473 |
FROM source WHERE source.shortname = shortname_ LIMIT 1
|
|
| 1474 | 1474 |
; |
| 1475 | 1475 |
|
| 1476 |
RETURN source_id; |
|
| 1476 |
RETURN source_id_;
|
|
| 1477 | 1477 |
END; |
| 1478 | 1478 |
$$; |
| 1479 | 1479 |
|
Also available in: Unified diff
bugfix: schemas/vegbien.sql: source_by_shortname(): resolved ambiguous column references by renaming PL/pgSQL vars and adding table qualifiers