Revision 12351
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/vegbien.my.sql | ||
|---|---|---|
| 868 | 868 |
|
| 869 | 869 |
|
| 870 | 870 |
-- |
| 871 |
-- Name: new_query_view_relation_name(varchar(255), varchar(255), varchar(255)); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 872 |
-- |
|
| 873 |
|
|
| 874 |
|
|
| 875 |
|
|
| 876 |
|
|
| 877 |
-- |
|
| 871 | 878 |
-- Name: query_relations(regclass); 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: new_query_view_relation_name(text, text, text); Type: FUNCTION; Schema: public_validations; Owner: - |
|
| 1955 |
-- |
|
| 1956 |
|
|
| 1957 |
CREATE FUNCTION new_query_view_relation_name(query_view_from text, query_view_to text, relation_from text) RETURNS text |
|
| 1958 |
LANGUAGE sql IMMUTABLE |
|
| 1959 |
AS $_$ |
|
| 1960 |
SELECT util.replace_suffix($3, $1, $2) |
|
| 1961 |
$_$; |
|
| 1962 |
|
|
| 1963 |
|
|
| 1964 |
-- |
|
| 1954 | 1965 |
-- Name: query_relations(regclass); Type: FUNCTION; Schema: public_validations; Owner: - |
| 1955 | 1966 |
-- |
| 1956 | 1967 |
|
Also available in: Unified diff
schemas/vegbien.sql: added new_query_view_relation_name()