Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: LIKE query problem
- From: Marc McIntyre <mmcintyre(at)squiz(dot)net>
- To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: LIKE query problem
- Date: Tue, 19 Sep 2006 13:16:48 +1000
- Message-id: <450F6120(dot)6010208(at)squiz(dot)net>
Thanks Tom,Is that documented somewhere? I can't seem to see any mention of it in the docs.
Tom Lane wrote:
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 ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo(at)postgresql(dot)org so that your message can get through to the mailing list cleanly
- References:
- LIKE query problem
- From: Marc McIntyre
- Re: LIKE query problem
- From: Tom Lane
- LIKE query problem
- Prev by Date: Re: LIKE query problem
- Next by Date: Re: Large tables (was: RAID 0 not as fast as expected)
- Previous by thread: Re: LIKE query problem
- Next by thread: Optimizing DELETE
- Indexes: