Project

General

Profile

« Previous | Next » 

Revision 11005

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

View differences:

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