Revision 12307
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 2101 | 2101 |
'; |
| 2102 | 2102 |
|
| 2103 | 2103 |
|
| 2104 |
-- |
|
| 2105 |
-- Name: validation_views(text); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2106 |
-- |
|
| 2107 |
|
|
| 2108 |
CREATE FUNCTION validation_views(schema text) RETURNS SETOF regclass |
|
| 2109 |
LANGUAGE sql STABLE |
|
| 2110 |
AS $_$ |
|
| 2111 |
SELECT * FROM util.show_views_like($1, '^_[[:alpha:]]+_\d+_') |
|
| 2112 |
$_$; |
|
| 2113 |
|
|
| 2114 |
|
|
| 2104 | 2115 |
SET search_path = public, pg_catalog; |
| 2105 | 2116 |
|
| 2106 | 2117 |
-- |
Also available in: Unified diff
schemas/vegbien.sql: added validation_views()