1/* contrib/pg_trgm/pg_trgm--1.4--1.5.sql */ 2 3-- complain if script is sourced in psql, rather than via ALTER EXTENSION 4\echo Use "ALTER EXTENSION pg_trgm UPDATE TO '1.5'" to load this file. \quit 5 6CREATE FUNCTION gtrgm_options(internal) 7RETURNS void 8AS 'MODULE_PATHNAME', 'gtrgm_options' 9LANGUAGE C IMMUTABLE PARALLEL SAFE; 10 11ALTER OPERATOR FAMILY gist_trgm_ops USING gist 12ADD FUNCTION 10 (text) gtrgm_options (internal); 13 14ALTER OPERATOR % (text, text) 15 SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); 16ALTER OPERATOR <% (text, text) 17 SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); 18ALTER OPERATOR %> (text, text) 19 SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); 20ALTER OPERATOR <<% (text, text) 21 SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); 22ALTER OPERATOR %>> (text, text) 23 SET (RESTRICT = matchingsel, JOIN = matchingjoinsel); 24