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