On Thu, Nov 10, 2005 at 05:26:45PM -0500, Andrew Dunstan wrote: > > > David Fetter wrote: > > >On Thu, Nov 10, 2005 at 04:08:29PM -0500, Andrew Dunstan wrote: > > > > > >>Tom Lane wrote: > >> > >>>I'm not convinced that using bigint-equivalent space for an enum is > >>>a mortal sin... > >>> > >>at least venial ... > > > >Heh. > > > >Would ORDER BY somehow know about enums' given ordering? > > ORDER BY (and all inequality operators) will reflect the defined > enumeration ordering, as happens today with enumkit-defined types. > > That is a fundamental requirement that I won't deviate from.
Great :) :) I hadn't understood how the enumkit stuff worked. Cheers, D -- David Fetter [EMAIL PROTECTED] http://fetter.org/ phone: +1 510 893 6100 mobile: +1 415 235 3778 Remember to vote! ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match