Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Mon, 18 Sep 2006 22:50:19 -0400
- Message-id: <26900(dot)1158634219(at)sss(dot)pgh(dot)pa(dot)us>
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
- Follow-Ups:
- Re: LIKE query problem
- From: Marc McIntyre
- Re: LIKE query problem
- References:
- LIKE query problem
- From: Marc McIntyre
- LIKE query problem
- Prev by Date: Re: Large tables (was: RAID 0 not as fast as
- Next by Date: Re: LIKE query problem
- Previous by thread: LIKE query problem
- Next by thread: Re: LIKE query problem
- Indexes: