Revision 11005
Added by Aaron Marcuse-Kubitza about 11 years ago
schemas/util.sql | ||
---|---|---|
815 | 815 |
|
816 | 816 |
|
817 | 817 |
-- |
818 |
-- Name: concat_esc(text, text); Type: FUNCTION; Schema: util; Owner: - |
|
819 |
-- |
|
820 |
|
|
821 |
CREATE FUNCTION concat_esc("left" text, "right" text) RETURNS text |
|
822 |
LANGUAGE sql IMMUTABLE |
|
823 |
AS $_$ |
|
824 |
SELECT util.esc_name__append($2, $1) |
|
825 |
$_$; |
|
826 |
|
|
827 |
|
|
828 |
-- |
|
818 | 829 |
-- Name: contains(text, text); Type: FUNCTION; Schema: util; Owner: - |
819 | 830 |
-- |
820 | 831 |
|
... | ... | |
2080 | 2091 |
); |
2081 | 2092 |
|
2082 | 2093 |
|
2094 |
-- |
|
2095 |
-- Name: ||%; Type: OPERATOR; Schema: util; Owner: - |
|
2096 |
-- |
|
2097 |
|
|
2098 |
CREATE OPERATOR ||% ( |
|
2099 |
PROCEDURE = concat_esc, |
|
2100 |
LEFTARG = text, |
|
2101 |
RIGHTARG = text |
|
2102 |
); |
|
2103 |
|
|
2104 |
|
|
2105 |
-- |
|
2106 |
-- Name: OPERATOR ||% (text, text); Type: COMMENT; Schema: util; Owner: - |
|
2107 |
-- |
|
2108 |
|
|
2109 |
COMMENT ON OPERATOR ||% (text, text) IS '% indicates an identifier, as in Perl hashes and one of the x86 assembler syntaxes for registers'; |
|
2110 |
|
|
2111 |
|
|
2083 | 2112 |
SET default_tablespace = ''; |
2084 | 2113 |
|
2085 | 2114 |
SET default_with_oids = false; |
Also available in: Unified diff
schemas/util.sql: added ||% operator to append to escaped strings (the % indicates an identifier, as in Perl hashes and one of the x86 assembler syntaxes for registers