Re: simple web search - Mailing list pgsql-sql

From Oleg Bartunov
Subject Re: simple web search
Date
Msg-id Pine.LNX.4.64.0702232129510.400@sn.sai.msu.ru
Whole thread Raw
In response to Re: simple web search  (chester c young <chestercyoung@yahoo.com>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Joe
Date:
Subject: Re: simple web search
Next
From: Louis-David Mitterrand
Date:
Subject: Re: simple web search