What's the best type of index for an ENUM column? - Mailing list pgsql-general

From Mike Christensen
Subject What's the best type of index for an ENUM column?
Date
Msg-id AANLkTikvLCQcev0WS_1VvCYIg5INi7JHlU89X5PAtOGY@mail.gmail.com
Whole thread Raw
Responses Re: What's the best type of index for an ENUM column?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I have a column in a table that's an ENUM type.  What's the best type
of index for this?  It seems if I use a btree index, that's more
optimized for doing greater than or less than comparisons which don't
apply to an enum.  I will only be doing equals comparisons on these
columns.  Thanks!

Mike

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Re: Does npgsql have a bunch of bugs with DB enums?
Next
From: Tom Lane
Date:
Subject: Re: What's the best type of index for an ENUM column?