2015-11-04 Antonin Houska <a...@cybertec.at>: > While prefix expression > > y like 'abc%' > > can be converted to > > y >= 'abc' > > (see expand_indexqual_opclause()), I'm not sure any kind of expansion is > possible for '%abc%' which would result in a b-tree searchable condition.
I think the question is not about using the b-tree for checking the condition, but about just retrieving the value for y from the index, and just using that to check the condition before fetching the corresponding tuple from the heap. Nicolas -- A. Because it breaks the logical sequence of discussion. Q. Why is top posting bad? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
