I think contrib/tsearch2
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/
is what you need.
Oleg
On Fri, 23 Feb 2007, chester c young 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.
>
> one solution would be a view:
>
> create view search_v as select
> 'show'::name as tab_nm,
> show_id as tab_pk,
> 'Show Name' as description,
> show_name as search
> from show
> union select
> 'story'::name,
> story_id,
> 'Story Title',
> title
> from story
> union ...
>
> your query would be
> select * from search_v where '$string' ilike search
>
> this would return a list the user could use to drill down further.
>
> many ways to skin this cat.
>
>
>
>
> ____________________________________________________________________________________
> It's here! Your new message!
> Get new email alerts with the free Yahoo! Toolbar.
> http://tools.search.yahoo.com/toolbar/features/mail/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
Regards, Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83