Add support for gin indexes on uuid arrays.

[uuid] / postgres / pduuid--1.0.1--1.1.sql

diff --git a/postgres/pduuid--1.0.1--1.1.sql b/postgres/pduuid--1.0.1--1.1.sql
new file mode 100644 (file)
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
+;