codekingpro/portable-devtools

1/* contrib/bloom/bloom--1.0.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION bloom" to load this file. \quit5 6CREATE FUNCTION blhandler(internal)7RETURNS index_am_handler8AS 'MODULE_PATHNAME'9LANGUAGE C;10 11-- Access method12CREATE ACCESS METHOD bloom TYPE INDEX HANDLER blhandler;13COMMENT ON ACCESS METHOD bloom IS 'bloom index access method';14 15-- Opclasses16 17CREATE OPERATOR CLASS int4_ops18DEFAULT FOR TYPE int4 USING bloom AS19	OPERATOR	1	=(int4, int4),20	FUNCTION	1	hashint4(int4);21 22CREATE OPERATOR CLASS text_ops23DEFAULT FOR TYPE text USING bloom AS24	OPERATOR	1	=(text, text),25	FUNCTION	1	hashtext(text);26