From: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
---|---|
To: | chester c young <chestercyoung(at)yahoo(dot)com> |
Cc: | Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>, sql pgsql <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: simple web search |
Date: | 2007-02-23 18:30:40 |
Message-ID: | Pine.LNX.4.64.0702232129510.400@sn.sai.msu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
From | Date | Subject | |
---|---|---|---|
Next Message | Joe | 2007-02-23 18:31:14 | Re: simple web search |
Previous Message | Stefan Becker | 2007-02-23 18:25:35 | how do I to generate a sequence Range or Set of integer constants |