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