Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] Select like when searching for whole word and optimizing it - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] Select like when searching for whole word and optimizing it
Date
Msg-id 28834.928939416@sss.pgh.pa.us
Whole thread Raw
In response to Select like when searching for whole word and optimizing it  (Michal Samek <webmaster@tony.cz>)
List pgsql-sql
Tree view 
Michal Samek <webmaster@tony.cz> writes:
> Maybe there is some better way to search for the whole word? 

I think you want to build a secondary table and search that.
Take a look at the stuff in contrib/fulltextindex; it may solve your
problem as-is, and if not you can probably adapt it to your needs...
        regards, tom lane

pgsql-sql by date:

Previous
From: Ingrith Andrea Correa Vargas
Date:
Subject: ...
Next
From: "Sergey S. Rakitin"
Date:
Subject: fields with float[48] type question