Revision 12260
Added by Aaron Marcuse-Kubitza almost 11 years ago
| util.sql | ||
|---|---|---|
| 1953 | 1953 |
|
| 1954 | 1954 |
|
| 1955 | 1955 |
-- |
| 1956 |
-- Name: qual_name(text[]); Type: FUNCTION; Schema: util; Owner: - |
|
| 1957 |
-- |
|
| 1958 |
|
|
| 1959 |
CREATE FUNCTION qual_name(VARIADIC elems text[]) RETURNS text |
|
| 1960 |
LANGUAGE sql IMMUTABLE |
|
| 1961 |
AS $_$ |
|
| 1962 |
SELECT string_agg(quote_ident(unnest), '.') FROM unnest($1) |
|
| 1963 |
$_$; |
|
| 1964 |
|
|
| 1965 |
|
|
| 1966 |
-- |
|
| 1956 | 1967 |
-- Name: qual_name(regclass); Type: FUNCTION; Schema: util; Owner: - |
| 1957 | 1968 |
-- |
| 1958 | 1969 |
|
Also available in: Unified diff
schemas/util.sql: added qual_name()