Partial matches on full text searches.

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Partial matches on full text searches.
Дата
Msg-id CAGuHJrMmesWoG7ZgHzxtRXOc-2T-CTEh1Et7jLt9fwkVhKXo0g@mail.gmail.com
обсуждение исходный текст
Список pgsql-general
I am trying to understand this bit of documentation about GIST and GIN searches

Also, * can be attached to a lexeme to specify prefix matching:

SELECT to_tsquery('supern:*A & star:A*B');
        to_tsquery
--------------------------
 'supern':*A & 'star':*AB


I tried various experiments but can't seem to be able to pinpoint a
way to matches similar to ILIKE.

Let's say I want to query some addresses and I want to find be able to
differentiate between PARK LANE and LINCOLN PARK and SPARK STREET  how
do I specify these in a tsquery?

Also...

Is it possible to do partial matches on values in a hstore I would
like to differentiate between ADDRESS=>"PARK LANE" and LAST_NAME=>PARK

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Four issues why "old elephants" lack performance: Explanation sought Four issues why "old elephants" lack performance: Explanation sought
Следующее
От: Fujii Masao
Дата:
Сообщение: Re: synchronous replication: blocking commit on the master