1/* contrib/hstore/hstore--1.6--1.7.sql */
2
3-- complain if script is sourced in psql, rather than via ALTER EXTENSION
4\echo Use "ALTER EXTENSION hstore UPDATE TO '1.7'" to load this file. \quit
5
6CREATE FUNCTION ghstore_options(internal)
7RETURNS void
8AS 'MODULE_PATHNAME', 'ghstore_options'
9LANGUAGE C IMMUTABLE PARALLEL SAFE;
10
11ALTER OPERATOR FAMILY gist_hstore_ops USING gist
12ADD FUNCTION 10 (hstore) ghstore_options (internal);
13
14ALTER OPERATOR ? (hstore, text)
15  SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);
16ALTER OPERATOR ?| (hstore, text[])
17  SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);
18ALTER OPERATOR ?& (hstore, text[])
19  SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);
20ALTER OPERATOR @> (hstore, hstore)
21  SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);
22ALTER OPERATOR <@ (hstore, hstore)
23  SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);
24ALTER OPERATOR @ (hstore, hstore)
25  SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);
26ALTER OPERATOR ~ (hstore, hstore)
27  SET (RESTRICT = matchingsel, JOIN = matchingjoinsel);
28