Re: simple web search
От | Louis-David Mitterrand |
---|---|
Тема | Re: simple web search |
Дата | |
Msg-id | 20070223183452.GA23406@apartia.fr обсуждение исходный текст |
Ответ на | Re: simple web search (Joe <dev@freedomcircle.net>) |
Ответы |
Re: simple web search
|
Список | pgsql-sql |
On Fri, Feb 23, 2007 at 01:31:14PM -0500, Joe wrote: > Hello Louis-David, > > On Fri, 2007-02-23 at 17:27 +0100, Louis-David Mitterrand wrote: > > I'm considering implementing a search box on my review web site > > http://lesculturelles.net and am looking for a simple way to match > > entered words against several columns on related tables: show.show_name, > > story.title, person.firtname, person.lastname, etc. > > > > What is the most elegant way to build a single query to match search > > words with multiple columns? > > You may want to take a look at contrib/tsearch2. Thanks Joe, I initially wanted to avoid dipping my toe into tsearch2 but it might be what I need after all :)
В списке pgsql-sql по дате отправления: