GIN over array of ENUMs - Mailing list pgsql-hackers

From Rod Taylor
Subject GIN over array of ENUMs
Date
Msg-id CAKddOFDaGUKqQM3Zmpj+n1W0qd=o=FU-Eo1BE87QHGkrD-ghNw@mail.gmail.com
Whole thread Raw
Responses Re: GIN over array of ENUMs
List 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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: [PATCH] unified frontend support for pg_malloc et al and palloc/pfree mulation (was xlogreader-v4)
Next
From: pgbuildfarm@jdrake.com
Date:
Subject: Re: PL/perl should fail on configure, not make