On Apr 2, 2013, at 8:03 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Are there any widely known non-built-in cases besides citext?
>
> Well, indxpath.c knows about text LIKE and network subset operators,
> and it would be nice if it knew how to do the same type of optimization
> for range inclusion, ie btree_indexed_col <@ range_constant. The latter
> doesn't seem implementable in the current infrastructure because ranges
> aren't all built-in types. I agree that the citext case isn't too
> compelling in isolation, but surely the range case is interesting.
Is this knowledge encapsulated in a to-do?
David