Revision 12328
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 2712 | 2712 |
CREATE FUNCTION show_views_like(name_regexp text, schema text) RETURNS SETOF regclass |
| 2713 | 2713 |
LANGUAGE sql STABLE |
| 2714 | 2714 |
AS $_$ |
| 2715 |
SELECT * FROM util.show_relations_like($1, $2, ARRAY['v']) |
|
| 2715 |
SELECT view_ |
|
| 2716 |
FROM util.show_relations_like($1, types := ARRAY['v']) view_ |
|
| 2717 |
WHERE util.schema(view_) = $2 |
|
| 2716 | 2718 |
$_$; |
| 2717 | 2719 |
|
| 2718 | 2720 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: show_views_like(): need to match the schema exactly, not via regexp like util.show_relations_like() does