X-Git-Url: https://pd.if.org/git/?p=uuid;a=blobdiff_plain;f=postgres%2Fpduuid--1.0.1--1.1.sql;fp=postgres%2Fpduuid--1.0.1--1.1.sql;h=ea180187c1ecd48156a42840ca1ea7085baf0f70;hp=0000000000000000000000000000000000000000;hb=17c5231ae64bd5b61abc13db6081f35d5da3ec44;hpb=5394807cb2d9c07c8689d3f48c9b05d20c44beb4 diff --git a/postgres/pduuid--1.0.1--1.1.sql b/postgres/pduuid--1.0.1--1.1.sql new file mode 100644 index 0000000..ea18018 --- /dev/null +++ b/postgres/pduuid--1.0.1--1.1.sql @@ -0,0 +1,14 @@ +CREATE OPERATOR CLASS gin__uuid_ops +DEFAULT +FOR TYPE _uuid USING gin +AS + OPERATOR 1 pg_catalog.&& (anyarray, anyarray), + OPERATOR 2 pg_catalog.@> (anyarray, anyarray), + OPERATOR 3 pg_catalog.<@ (anyarray, anyarray), + OPERATOR 4 pg_catalog.= (anyarray, anyarray), + FUNCTION 1 uuid_cmp (uuid, uuid), + FUNCTION 2 ginarrayextract (anyarray, internal, internal), + FUNCTION 3 ginqueryarrayextract (anyarray, internal, int2, internal, internal, internal, internal), + FUNCTION 4 ginarrayconsistent (internal, int2, anyarray, int4, internal, internal, internal, internal), + STORAGE uuid +;