3
-- Adjust this setting to control where the objects get created.
4
SET search_path = public;
8
CREATE OR REPLACE FUNCTION hstore_in(cstring)
13
CREATE OR REPLACE FUNCTION hstore_out(hstore)
25
CREATE OR REPLACE FUNCTION fetchval(hstore,text)
28
LANGUAGE C STRICT IMMUTABLE;
36
CREATE OR REPLACE FUNCTION isexists(hstore,text)
38
AS 'MODULE_PATHNAME','exists'
39
LANGUAGE C STRICT IMMUTABLE;
41
CREATE OR REPLACE FUNCTION exist(hstore,text)
43
AS 'MODULE_PATHNAME','exists'
44
LANGUAGE C STRICT IMMUTABLE;
54
CREATE OR REPLACE FUNCTION isdefined(hstore,text)
56
AS 'MODULE_PATHNAME','defined'
57
LANGUAGE C STRICT IMMUTABLE;
59
CREATE OR REPLACE FUNCTION defined(hstore,text)
61
AS 'MODULE_PATHNAME','defined'
62
LANGUAGE C STRICT IMMUTABLE;
64
CREATE OR REPLACE FUNCTION delete(hstore,text)
66
AS 'MODULE_PATHNAME','delete'
67
LANGUAGE C STRICT IMMUTABLE;
69
CREATE OR REPLACE FUNCTION hs_concat(hstore,hstore)
72
LANGUAGE C STRICT IMMUTABLE;
80
CREATE OR REPLACE FUNCTION hs_contains(hstore,hstore)
83
LANGUAGE C STRICT IMMUTABLE;
85
CREATE OR REPLACE FUNCTION hs_contained(hstore,hstore)
88
LANGUAGE C STRICT IMMUTABLE;
93
PROCEDURE = hs_contains,
102
PROCEDURE = hs_contained,
112
PROCEDURE = hs_contains,
121
PROCEDURE = hs_contained,
127
CREATE OR REPLACE FUNCTION tconvert(text,text)
130
LANGUAGE C IMMUTABLE;
138
CREATE OR REPLACE FUNCTION akeys(hstore)
141
LANGUAGE C STRICT IMMUTABLE;
143
CREATE OR REPLACE FUNCTION avals(hstore)
146
LANGUAGE C STRICT IMMUTABLE;
148
CREATE OR REPLACE FUNCTION skeys(hstore)
151
LANGUAGE C STRICT IMMUTABLE;
153
CREATE OR REPLACE FUNCTION svals(hstore)
156
LANGUAGE C STRICT IMMUTABLE;
158
CREATE OR REPLACE FUNCTION each(IN hs hstore,
163
LANGUAGE C STRICT IMMUTABLE;
167
-- define the GiST support methods
171
CREATE OR REPLACE FUNCTION ghstore_in(cstring)
176
CREATE OR REPLACE FUNCTION ghstore_out(ghstore)
181
CREATE TYPE ghstore (
187
CREATE OR REPLACE FUNCTION ghstore_compress(internal)
190
LANGUAGE C IMMUTABLE;
192
CREATE OR REPLACE FUNCTION ghstore_decompress(internal)
195
LANGUAGE C IMMUTABLE;
197
CREATE OR REPLACE FUNCTION ghstore_penalty(internal,internal,internal)
200
LANGUAGE C IMMUTABLE STRICT;
202
CREATE OR REPLACE FUNCTION ghstore_picksplit(internal, internal)
205
LANGUAGE C IMMUTABLE;
207
CREATE OR REPLACE FUNCTION ghstore_union(internal, internal)
210
LANGUAGE C IMMUTABLE;
212
CREATE OR REPLACE FUNCTION ghstore_same(internal, internal, internal)
215
LANGUAGE C IMMUTABLE;
217
CREATE OR REPLACE FUNCTION ghstore_consistent(internal,internal,int,oid,internal)
220
LANGUAGE C IMMUTABLE;
222
-- register the opclass for indexing (not as default)
223
CREATE OPERATOR CLASS gist_hstore_ops
224
DEFAULT FOR TYPE hstore USING gist
227
OPERATOR 9 ?(hstore,text) ,
231
FUNCTION 1 ghstore_consistent (internal, internal, int, oid, internal),
232
FUNCTION 2 ghstore_union (internal, internal),
233
FUNCTION 3 ghstore_compress (internal),
234
FUNCTION 4 ghstore_decompress (internal),
235
FUNCTION 5 ghstore_penalty (internal, internal, internal),
236
FUNCTION 6 ghstore_picksplit (internal, internal),
237
FUNCTION 7 ghstore_same (internal, internal, internal),
240
-- define the GIN support methods
242
CREATE OR REPLACE FUNCTION gin_extract_hstore(internal, internal)
245
LANGUAGE C IMMUTABLE;
247
CREATE OR REPLACE FUNCTION gin_extract_hstore_query(internal, internal, int2, internal, internal)
250
LANGUAGE C IMMUTABLE;
252
CREATE OR REPLACE FUNCTION gin_consistent_hstore(internal, int2, internal, int4, internal, internal)
255
LANGUAGE C IMMUTABLE;
257
CREATE OPERATOR CLASS gin_hstore_ops
258
DEFAULT FOR TYPE hstore USING gin
261
OPERATOR 9 ?(hstore,text),
262
FUNCTION 1 bttextcmp(text,text),
263
FUNCTION 2 gin_extract_hstore(internal, internal),
264
FUNCTION 3 gin_extract_hstore_query(internal, internal, int2, internal, internal),
265
FUNCTION 4 gin_consistent_hstore(internal, int2, internal, int4, internal, internal),