Re: WIP: extensible enums

On 10/17/2010 03:56 PM, Tom Lane wrote:

[clever scheme to treat even numbered enum Oids as sorted]
>   The one problem I can see with this is that it's only partially
> on-disk-compatible with existing enum types: it'll almost certainly
> think that they require slow comparison, even when they don't.
> Maybe that's acceptable.

Thinking more about this, could we do some sort of hybrid scheme that 
stashes the 'oids are sorted correctly' property of the type somewhat 
like what I proposed?

Binary upgrade would be mildly tricky but not impossible.

cheers

andrew