Postgres Pro
Downloads
Home   >   mailing lists

Re: LIKE query problem - Mailing list pgsql-performance

From Tom Lane
Subject Re: LIKE query problem
Date
Msg-id 26900.1158634219@sss.pgh.pa.us
Whole thread Raw
In response to LIKE query problem  (Marc McIntyre <mmcintyre@squiz.net>)
Responses Re: LIKE query problem
List pgsql-performance
Tree view 
Marc McIntyre <mmcintyre@squiz.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

pgsql-performance by date:

Previous
From: "Luke Lonergan"
Date:
Subject: Re: Large tables (was: RAID 0 not as fast as
Next
From: Marc McIntyre
Date:
Subject: Re: LIKE query problem