Text Searching?
От | Announce |
---|---|
Тема | Text Searching? |
Дата | |
Msg-id | KBEKKNMFLELKGIADDEPEMEEPCBAA.truthhurts@insightbb.com обсуждение исходный текст |
Ответы |
Re: Text Searching?
|
Список | pgsql-novice |
I have a couple of best practice questions for doing web searches on Postgres tables. Let's say I have a table of employees with A LOT of rows that I would like to regularly do searches on (from a PHP web page, etc): EMPLOYEES (table) -------------------------------- empl_id pri key firstname text or varchar middlename text or varchar lastname text or varchar fullname text or varchar (firstname+middle+lastname) Contrived, I know. ANYWAY... A. Any suggestions for doing full-text searches in Postgres? I have some primitive ideas of how to do this, but from what I can see, using LIKE together with an expression that starts with "%" does not make use of the indexes I have created. How can I set myself up to perform the fastest possible search? B. How should the fields be defined? Should they be VARCHAR with a character limit or just TEXT,etc? Thanks, Aaron
В списке pgsql-novice по дате отправления: