Re: LIKE query problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Marc McIntyre <mmcintyre(at)squiz(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: LIKE query problem
Date: 2006-09-19 02:50:19
Message-ID: 26900.1158634219@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Marc McIntyre <mmcintyre(at)squiz(dot)net> writes:
> ... Is there a way to perform this efficiently in one query ?

No, because you're hoping for an indexscan optimization of a LIKE
query, and that can only happen if the pattern is a plan-time constant.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Marc McIntyre 2006-09-19 03:16:48 Re: LIKE query problem
Previous Message Luke Lonergan 2006-09-19 01:14:39 Re: Large tables (was: RAID 0 not as fast as