Re: What type of index do I need for this JOIN?

Поиск
Список
Период
Сортировка
От Robert James
Тема Re: What type of index do I need for this JOIN?
Дата
Msg-id CAGYyBgi=nkTWLca+bvXsgv6_ffCD=L+FXJ0JtCZS_V+X04TawQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What type of index do I need for this JOIN?  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: What type of index do I need for this JOIN?  (Kevin Grittner <kgrittn@ymail.com>)
Список pgsql-general
On 8/14/13, Kevin Grittner <kgrittn@ymail.com> wrote:
> Robert James <srobertjames@gmail.com> wrote:
>
>> I'm confused: What's the difference between
>>   col LIKE  'foo%'
>> and
>>   col LIKE f1 || '%'
>> ?
>
> The planner knows that 'foo%' doesn't start with a wildcard.
>
>> Either way, it's anchored to the beginning of the string.
>
> Not necessarily.

I see, yes, f1 might include a wildcard.

Is there a way to escape f1 so that wildcards aren't interpreted?
That's anyway the behavior I need, of course.  And will that help the
planner?

What type of index will help the planner here?


В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Getting list of supported types in Postgres
Следующее
От: Jayadevan M
Дата:
Сообщение: Re: Debugging Postgres?