Gleb Kouzmenko <gleb(at)well(dot)ru> writes:
> I quoted two EXPLAINs below again: WHERE i<<'IP' and WHERE 'IP'>>i is
> logically equivalent, but are planned differently
If you'd like to fix that, see match_special_index_operator() and
expand_indexqual_conditions() in src/backend/optimizer/path/indxpath.c.
I can't get very excited about it myself.
regards, tom lane