Revision 12307
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 923 | 923 |
|
| 924 | 924 |
|
| 925 | 925 |
|
| 926 |
-- |
|
| 927 |
-- Name: validation_views(varchar(255)); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 928 |
-- |
|
| 926 | 929 |
|
| 927 | 930 |
|
| 931 |
|
|
| 932 |
|
|
| 933 |
|
|
| 934 |
|
|
| 928 | 935 |
-- |
| 929 | 936 |
-- Name: analytical_stem; Type: TABLE; Schema: public; Owner: -; Tablespace: |
| 930 | 937 |
-- |
| trunk/schemas/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()