Indexing of LIKE queries is broken in current sources

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Indexing of LIKE queries is broken in current sources
Date: 2000-09-13 19:25:26
Message-ID: 10307.968873126@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mitch Vincent 2000-09-13 20:04:32 Linux / PostgreSQL question
Previous Message Ricardo Muggli 2000-09-13 18:50:32 minor fixes for regress