Re: Performance for seq. scans

Поиск
Список
Период
Сортировка
От bmccoy@chapelperilous.net
Тема Re: Performance for seq. scans
Дата
Msg-id Pine.LNX.4.10.10007261256220.15843-100000@chapelperilous.net
обсуждение исходный текст
Ответ на Re: Performance for seq. scans  (Jules Bean <jules@jellybean.co.uk>)
Список pgsql-general
On Wed, 26 Jul 2000, Jules Bean wrote:

> If I understand you correctly, that's word-based? It's just splitting
> on whitespace and punctuation?  Unfortunately, that's not quite what
> we need --- our wildcard searches needn't have their '%' on word
> boundaries.

You can have it search on less than word boundaries.  It uses a regexp in
the query statement, and actually will match against sub-strings.  Check
the documentation.  It talks about how this works.

Brett W. McCoy
                                         http://www.chapelperilous.net/~bmccoy/
-------------------------------------------------------------------------------
If everything is coming your way then you're in the wrong lane.



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

Предыдущее
От:
Дата:
Сообщение: Re: Access 97 Database and Postgres
Следующее
От: Michael Blakeley
Дата:
Сообщение: Re: Performance for seq. scans