From: | Rod Taylor <pg(at)rbt(dot)ca> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | GIN over array of ENUMs |
Date: | 2013-01-10 17:08:45 |
Message-ID: | CAKddOFDaGUKqQM3Zmpj+n1W0qd=o=FU-Eo1BE87QHGkrD-ghNw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I wish to create this data structure but GIN does not currently support an
array of ENUM. Is intarray() a good place to look into adding ENUM support
or is there already an operator class for working supports enums that I
simply don't see at the moment.
This is being done as an alternative to a very large number of boolean
columns which are rarely true (under 1%).
CREATE TYPE feature AS ENUM ('item1', 'item2', 'item3');
CREATE TABLE test (id serial PRIMARY KEY, features feature[]);
CREATE INDEX test_features_idx ON test USING GIN (features, id);
ERROR: data type feature[] has no default operator class for access method
"gin"
HINT: You must specify an operator class for the index or define a default
operator class for the data type.
Thanks in advance,
Rod
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-01-10 17:09:15 | Re: pg_dump --pretty-print-views |
Previous Message | David Fetter | 2013-01-10 16:51:44 | Re: pg_dump --pretty-print-views |