[HACKERS] Indexing of LIKE queries is broken in current sources

[Tom Lane]

I noticed today that current sources are not able to use an index
for a query like
select * from foo where bar like 'xyz%';

It seems that the parser now emits some kind of function call for LIKE
expressions, whereas the optimizer's code to use indexes for LIKE is
looking for an operator.

I have more pressing things to do than try to teach the optimizer about
looking for function calls as well as operators, so I recommend
reverting the parser's output to what it was.

regards, tom lane