Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: What's the best type of index for an ENUM column?
Date
Msg-id 27110.1275969249@sss.pgh.pa.us
Whole thread Raw
In response to Re: What's the best type of index for an ENUM column?  (Mike Christensen <mike@kitchenpc.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Re: What's the best type of index for an ENUM column?
Next
From: Dean Rasheed
Date:
Subject: Re: Deferrable constraint checking with SAVEPOINT?