Revision 13381
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 2630 | 2630 |
|
| 2631 | 2631 |
|
| 2632 | 2632 |
-- |
| 2633 |
-- Name: query_relations(regclass, int(11), anyelement); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 2633 |
-- Name: query_relations(regclass, anyelement); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 2634 | 2634 |
-- |
| 2635 | 2635 |
|
| 2636 | 2636 |
|
| 2637 | 2637 |
|
| 2638 | 2638 |
|
| 2639 | 2639 |
-- |
| 2640 |
-- Name: FUNCTION query_relations(query_view regclass, max_prefix_len int(11), schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 2640 |
-- Name: FUNCTION query_relations(query_view regclass, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: - |
|
| 2641 | 2641 |
-- |
| 2642 | 2642 |
|
| 2643 | 2643 |
|
| trunk/schemas/public_.sql | ||
|---|---|---|
| 4288 | 4288 |
|
| 4289 | 4289 |
|
| 4290 | 4290 |
-- |
| 4291 |
-- Name: query_relations(regclass, integer, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 4291 |
-- Name: query_relations(regclass, anyelement); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 4292 | 4292 |
-- |
| 4293 | 4293 |
|
| 4294 |
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
|
|
| 4294 |
CREATE FUNCTION query_relations(query_view regclass, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS SETOF regclass |
|
| 4295 | 4295 |
LANGUAGE plpgsql |
| 4296 | 4296 |
SET search_path TO pg_temp |
| 4297 | 4297 |
AS $_$ |
| ... | ... | |
| 4301 | 4301 |
RETURN QUERY |
| 4302 | 4302 |
SELECT * FROM util.show_relations_like( |
| 4303 | 4303 |
truncated_prefixed_name_regexp(util.name($1)), |
| 4304 |
(CASE WHEN util.schema($1) = util.schema($3) -- is in public_validations?
|
|
| 4304 |
(CASE WHEN util.schema($1) = util.schema($2) -- is in public_validations?
|
|
| 4305 | 4305 |
THEN '' -- output query, so remove in *all* schemas |
| 4306 | 4306 |
ELSE util.schema_regexp($1) -- input query, so remove only in datasource's schema |
| 4307 | 4307 |
END) |
| ... | ... | |
| 4312 | 4312 |
|
| 4313 | 4313 |
|
| 4314 | 4314 |
-- |
| 4315 |
-- Name: FUNCTION query_relations(query_view regclass, max_prefix_len integer, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 4315 |
-- Name: FUNCTION query_relations(query_view regclass, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: - |
|
| 4316 | 4316 |
-- |
| 4317 | 4317 |
|
| 4318 |
COMMENT ON FUNCTION query_relations(query_view regclass, max_prefix_len integer, schema_anchor anyelement) IS '
|
|
| 4318 |
COMMENT ON FUNCTION query_relations(query_view regclass, schema_anchor anyelement) IS ' |
|
| 4319 | 4319 |
query_view: if an output query, will remove in *all* schemas |
| 4320 | 4320 |
max_prefix_len: when str may have been truncated (eg. as a table name) due to |
| 4321 | 4321 |
the prepending of a prefix, support prefixes up to this length. should be |
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 4288 | 4288 |
|
| 4289 | 4289 |
|
| 4290 | 4290 |
-- |
| 4291 |
-- Name: query_relations(regclass, integer, anyelement); Type: FUNCTION; Schema: public_validations; Owner: -
|
|
| 4291 |
-- Name: query_relations(regclass, anyelement); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 4292 | 4292 |
-- |
| 4293 | 4293 |
|
| 4294 |
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
|
|
| 4294 |
CREATE FUNCTION query_relations(query_view regclass, schema_anchor anyelement DEFAULT NULL::schema_anchor) RETURNS SETOF regclass |
|
| 4295 | 4295 |
LANGUAGE plpgsql |
| 4296 | 4296 |
SET search_path TO pg_temp |
| 4297 | 4297 |
AS $_$ |
| ... | ... | |
| 4301 | 4301 |
RETURN QUERY |
| 4302 | 4302 |
SELECT * FROM util.show_relations_like( |
| 4303 | 4303 |
truncated_prefixed_name_regexp(util.name($1)), |
| 4304 |
(CASE WHEN util.schema($1) = util.schema($3) -- is in public_validations?
|
|
| 4304 |
(CASE WHEN util.schema($1) = util.schema($2) -- is in public_validations?
|
|
| 4305 | 4305 |
THEN '' -- output query, so remove in *all* schemas |
| 4306 | 4306 |
ELSE util.schema_regexp($1) -- input query, so remove only in datasource's schema |
| 4307 | 4307 |
END) |
| ... | ... | |
| 4312 | 4312 |
|
| 4313 | 4313 |
|
| 4314 | 4314 |
-- |
| 4315 |
-- Name: FUNCTION query_relations(query_view regclass, max_prefix_len integer, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: -
|
|
| 4315 |
-- Name: FUNCTION query_relations(query_view regclass, schema_anchor anyelement); Type: COMMENT; Schema: public_validations; Owner: - |
|
| 4316 | 4316 |
-- |
| 4317 | 4317 |
|
| 4318 |
COMMENT ON FUNCTION query_relations(query_view regclass, max_prefix_len integer, schema_anchor anyelement) IS '
|
|
| 4318 |
COMMENT ON FUNCTION query_relations(query_view regclass, schema_anchor anyelement) IS ' |
|
| 4319 | 4319 |
query_view: if an output query, will remove in *all* schemas |
| 4320 | 4320 |
max_prefix_len: when str may have been truncated (eg. as a table name) due to |
| 4321 | 4321 |
the prepending of a prefix, support prefixes up to this length. should be |
Also available in: Unified diff
schemas/public_.sql: query_relations(): removed no longer used max_prefix_len default param