1 /* contrib/hstore/hstore--1.1--1.2.sql */
3 -- complain if script is sourced in psql, rather than via ALTER EXTENSION
4 \echo Use "ALTER EXTENSION hstore UPDATE TO '1.2'" to load this file. \quit
7 -- A version of 1.1 was shipped with these objects mistakenly in 9.3.0.
8 -- Therefore we only add them if we detect that they aren't already there and
9 -- dependent on the extension.
20 ON p.proname = 'hstore_to_json_loose'
21 AND d.classid = 'pg_proc'::regclass
23 AND d.refclassid = 'pg_extension'::regclass
26 AND x.extname = 'hstore';
31 CREATE FUNCTION hstore_to_json(hstore)
33 AS 'MODULE_PATHNAME', 'hstore_to_json'
34 LANGUAGE C IMMUTABLE STRICT;
36 CREATE CAST (hstore AS json)
37 WITH FUNCTION hstore_to_json(hstore);
39 CREATE FUNCTION hstore_to_json_loose(hstore)
41 AS 'MODULE_PATHNAME', 'hstore_to_json_loose'
42 LANGUAGE C IMMUTABLE STRICT;