Revision 12267
Added by Aaron Marcuse-Kubitza almost 11 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 1968 | 1968 |
-- |
| 1969 | 1969 |
|
| 1970 | 1970 |
CREATE FUNCTION qual_name(table_ regclass) RETURNS text |
| 1971 |
LANGUAGE sql STABLE |
|
| 1971 |
LANGUAGE sql STABLE STRICT |
|
| 1972 |
SET search_path TO pg_temp |
|
| 1972 | 1973 |
AS $_$ |
| 1973 |
SELECT util.qual_name($1::text::regtype)
|
|
| 1974 |
SELECT $1::text
|
|
| 1974 | 1975 |
$_$; |
| 1975 | 1976 |
|
| 1976 | 1977 |
|
| 1977 | 1978 |
-- |
| 1979 |
-- Name: qual_name(regtype); Type: FUNCTION; Schema: util; Owner: - |
|
| 1980 |
-- |
|
| 1981 |
|
|
| 1982 |
CREATE FUNCTION qual_name(type regtype) RETURNS text |
|
| 1983 |
LANGUAGE sql STABLE STRICT |
|
| 1984 |
SET search_path TO pg_temp |
|
| 1985 |
AS $_$ |
|
| 1986 |
SELECT $1::text |
|
| 1987 |
$_$; |
|
| 1988 |
|
|
| 1989 |
|
|
| 1990 |
-- |
|
| 1991 |
-- Name: FUNCTION qual_name(type regtype); Type: COMMENT; Schema: util; Owner: - |
|
| 1992 |
-- |
|
| 1993 |
|
|
| 1994 |
COMMENT ON FUNCTION qual_name(type regtype) IS ' |
|
| 1995 |
a type''s schema-qualified name |
|
| 1996 |
'; |
|
| 1997 |
|
|
| 1998 |
|
|
| 1999 |
-- |
|
| 1978 | 2000 |
-- Name: raise_notice(text); Type: FUNCTION; Schema: util; Owner: - |
| 1979 | 2001 |
-- |
| 1980 | 2002 |
|
| ... | ... | |
| 2697 | 2719 |
|
| 2698 | 2720 |
|
| 2699 | 2721 |
-- |
| 2700 |
-- Name: qual_name(regtype); Type: FUNCTION; Schema: util; Owner: - |
|
| 2701 |
-- |
|
| 2702 |
|
|
| 2703 |
CREATE FUNCTION qual_name(type regtype) RETURNS text |
|
| 2704 |
LANGUAGE sql STABLE STRICT |
|
| 2705 |
SET search_path TO pg_temp |
|
| 2706 |
AS $_$ |
|
| 2707 |
SELECT $1::text |
|
| 2708 |
$_$; |
|
| 2709 |
|
|
| 2710 |
|
|
| 2711 |
-- |
|
| 2712 |
-- Name: FUNCTION qual_name(type regtype); Type: COMMENT; Schema: util; Owner: - |
|
| 2713 |
-- |
|
| 2714 |
|
|
| 2715 |
COMMENT ON FUNCTION qual_name(type regtype) IS ' |
|
| 2716 |
a type''s schema-qualified name |
|
| 2717 |
'; |
|
| 2718 |
|
|
| 2719 |
|
|
| 2720 |
-- |
|
| 2721 | 2722 |
-- Name: typeof(text, regtype); Type: FUNCTION; Schema: util; Owner: - |
| 2722 | 2723 |
-- |
| 2723 | 2724 |
|
Also available in: Unified diff
schemas/util.sql: qual_name(table_ regclass): use ::text with search_path=pg_temp like qual_name(type regtype), rather than casting to text and then using qual_name(type regtype)