Re: What's the best type of index for an ENUM column?

Mike Christensen <mike@kitchenpc.com> writes:
> Just to double check, an enum type is gonna be stored on the disk as
> an integer, correct?  And all indexes will be based on the integer
> value of the enum?

Well, strictly speaking it's an OID, but yeah.  The label is only
of interest for I/O.

            regards, tom lane