Datasetpublic

codekingpro/portable-devtools

sourceHugging Faceupdated 5mo agoView on Hugging Face

1likes14kdownloads

rootpgsqlshareextensiondummy_index_am--1.0.sql

dummy_index_am--1.0.sql20 linesDownload Raw Back to extension

1/* src/test/modules/dummy_index_am/dummy_index_am--1.0.sql */2 3-- complain if script is sourced in psql, rather than via CREATE EXTENSION4\echo Use "CREATE EXTENSION dummy_index_am" to load this file. \quit5 6CREATE FUNCTION dihandler(internal)7RETURNS index_am_handler8AS 'MODULE_PATHNAME'9LANGUAGE C;10 11-- Access method12CREATE ACCESS METHOD dummy_index_am TYPE INDEX HANDLER dihandler;13COMMENT ON ACCESS METHOD dummy_index_am IS 'dummy index access method';14 15-- Operator classes16CREATE OPERATOR CLASS int4_ops17DEFAULT FOR TYPE int4 USING dummy_index_am AS18  OPERATOR 1 = (int4, int4),19  FUNCTION 1 hashint4(int4);20