SQL optimization - WHERE SomeField STARTING WITH ...

Поиск
Список
Период
Сортировка
От Bill
Тема SQL optimization - WHERE SomeField STARTING WITH ...
Дата
Msg-id 48B6EA27.30503@dbginc.com
обсуждение исходный текст
Ответы Re: SQL optimization - WHERE SomeField STARTING WITH ...  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Re: SQL optimization - WHERE SomeField STARTING WITH ...  (Tino Wildenhain <tino@wildenhain.de>)
Re: SQL optimization - WHERE SomeField STARTING WITH ...  (Peter Eisentraut <peter_e@gmx.net>)
Список pgsql-general
The SQL database servers I have worked with cannot use and index for a
SELECT of the form

SELECT * FROM ATABLE
WHERE AFIELD LIKE ?

because there is no way to know the location of the wild card until the
parameter value is known. InterBase and Firebird allow

SELECT * FROM ATABLE
WHERE AFIELD STARTING WITH ?

which is equivalent to LIKE  'ABC%' and will use an index on AFIELD. Is
there a similar syntax in PostgreSQL?

Bill

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: strange explain analyze output
Следующее
От: Tom Lane
Дата:
Сообщение: Re: temp schemas