Project

General

Profile

« Previous | Next » 

Revision 10308

schemas/util.sql: added text[] => text operator, analogous to text => text for multiple keys (uses hstore(keys text[], value text))

View differences:

schemas/util.sql
1682 1682
);
1683 1683

  
1684 1684

  
1685
--
1686
-- Name: =>; Type: OPERATOR; Schema: util; Owner: -
1687
--
1688

  
1689
CREATE OPERATOR => (
1690
    PROCEDURE = hstore,
1691
    LEFTARG = text[],
1692
    RIGHTARG = text
1693
);
1694

  
1695

  
1696
--
1697
-- Name: OPERATOR => (text[], text); Type: COMMENT; Schema: util; Owner: -
1698
--
1699

  
1700
COMMENT ON OPERATOR => (text[], text) IS 'usage: array[''key1'', ...] => ''value''';
1701

  
1702

  
1685 1703
SET default_tablespace = '';
1686 1704

  
1687 1705
SET default_with_oids = false;

Also available in: Unified diff