Revision 12335
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 868 | 868 |
|
| 869 | 869 |
|
| 870 | 870 |
-- |
| 871 |
-- Name: query_views(regclass); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 872 |
-- |
|
| 873 |
|
|
| 874 |
|
|
| 875 |
|
|
| 876 |
|
|
| 877 |
-- |
|
| 871 | 878 |
-- Name: remake_diff_table(regclass, anyelement); Type: FUNCTION; Schema: public_validations; Owner: - |
| 872 | 879 |
-- |
| 873 | 880 |
|
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 1951 | 1951 |
SET search_path = public_validations, pg_catalog; |
| 1952 | 1952 |
|
| 1953 | 1953 |
-- |
| 1954 |
-- Name: query_views(regclass); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1955 |
-- |
|
| 1956 |
|
|
| 1957 |
CREATE FUNCTION query_views(query_view regclass) RETURNS SETOF regclass |
|
| 1958 |
LANGUAGE sql STABLE |
|
| 1959 |
AS $_$ |
|
| 1960 |
SELECT * |
|
| 1961 |
FROM util.show_relations_like('^.*'||util.regexp_quote(util.name($1))||'$')
|
|
| 1962 |
$_$; |
|
| 1963 |
|
|
| 1964 |
|
|
| 1965 |
-- |
|
| 1954 | 1966 |
-- Name: remake_diff_table(regclass, anyelement); Type: FUNCTION; Schema: public_validations; Owner: - |
| 1955 | 1967 |
-- |
| 1956 | 1968 |
|
Also available in: Unified diff
schemas/vegbien.sql: added public_validations.query_views()