Revision 12505
Added by Aaron Marcuse-Kubitza over 10 years ago
| vegbien.sql | ||
|---|---|---|
| 2026 | 2026 |
|
| 2027 | 2027 |
|
| 2028 | 2028 |
-- |
| 2029 |
-- Name: query_relations(regclass, integer); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2029 |
-- Name: query_relations(regclass, integer, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 2030 | 2030 |
-- |
| 2031 | 2031 |
|
| 2032 |
CREATE FUNCTION query_relations(query_view regclass, max_prefix_len integer DEFAULT query_view_relation_max_prefix_len()) RETURNS SETOF regclass |
|
| 2032 |
CREATE FUNCTION query_relations(query_view regclass, max_prefix_len integer DEFAULT query_view_relation_max_prefix_len(), schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS SETOF regclass
|
|
| 2033 | 2033 |
LANGUAGE sql STABLE |
| 2034 | 2034 |
AS $_$ |
| 2035 | 2035 |
SELECT * FROM util.show_relations_like( |
| 2036 |
util.truncated_prefixed_name_regexp(util.name($1), $2)) |
|
| 2036 |
util.truncated_prefixed_name_regexp(util.name($1), $2), |
|
| 2037 |
(CASE WHEN util.schema($1) = util.schema($3) -- is in public_validations? |
|
| 2038 |
THEN '' -- output query, so remove in *all* schemas |
|
| 2039 |
ELSE util.schema_regexp($1) --input query, so remove only in datasource's schema |
|
| 2040 |
END) |
|
| 2041 |
) |
|
| 2037 | 2042 |
$_$; |
| 2038 | 2043 |
|
| 2039 | 2044 |
|
| 2040 | 2045 |
-- |
| 2041 |
-- Name: FUNCTION query_relations(query_view regclass, max_prefix_len integer); Type: COMMENT; Schema: public_validations; Owner: - |
|
| 2046 |
-- Name: FUNCTION query_relations(query_view regclass, max_prefix_len integer, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 2042 | 2047 |
-- |
| 2043 | 2048 |
|
| 2044 |
COMMENT ON FUNCTION query_relations(query_view regclass, max_prefix_len integer) IS ' |
|
| 2049 |
COMMENT ON FUNCTION query_relations(query_view regclass, max_prefix_len integer, schema_anchor anyelement) IS ' |
|
| 2050 |
query_view: if an output query, will remove in *all* schemas |
|
| 2045 | 2051 |
max_prefix_len: when str may have been truncated (eg. as a table name) due to |
| 2046 | 2052 |
the prepending of a prefix, support prefixes up to this length. should be |
| 2047 | 2053 |
left as the default value. |
| 2054 |
schema_anchor: identifies this function''s schema. should be left as the default. |
|
| 2048 | 2055 |
'; |
| 2049 | 2056 |
|
| 2050 | 2057 |
|
Also available in: Unified diff
schemas/util.sql: query_relations(): support passing in an input query instead of an output query, which will remove only in the datasource's schema. (note that it was not clear that passing in an input-side query was not previously supported.)