FW: Advanced search form

Lists: pgsql-general
From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: FW: Advanced search form
Date: 2005-12-07 13:18:34
Message-ID: 20051207131834.GG2107@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Hello PGSQL-Gurus,

I have already ask this on pgsql-php and php-db but unfortunatly
gotten no answer.

I have a search form and I like to add advanced search options like

"this is a search" -XXX Test

which mean,

1) "this is a search" must be in this order
2) -XXX Do not find XXX contents
3) Test AND

Does anyone has a PHP/PGSQL code sniplet?

Thanks
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

----- End forwarded message -----
******************************************************************
* Do not Cc: me, because I am on THIS list, if I write here *
* Keine Cc: am mich, bin auf DIESER Liste wenn ich hier schreibe *
******************************************************************

Hello,

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)


From: Richard Huxton <dev(at)archonet(dot)com>
To: Michelle Konzack <linux4michelle(at)freenet(dot)de>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: FW: Advanced search form
Date: 2005-12-07 18:16:43
Message-ID: 4397270B.9000809@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Michelle Konzack wrote:
> Hello PGSQL-Gurus,
>
> I have already ask this on pgsql-php and php-db but unfortunatly
> gotten no answer.
>
> I have a search form and I like to add advanced search options like
>
> "this is a search" -XXX Test
>
> which mean,
>
> 1) "this is a search" must be in this order
> 2) -XXX Do not find XXX contents
> 3) Test AND
>
> Does anyone has a PHP/PGSQL code sniplet?

Um - not sure what this has to do with PostgreSQL. You'll probably have
more luck at one of the many PHP developer sites. I shouldn't be
surprised if there was something available in the PEAR repository too.

--
Richard Huxton
Archonet Ltd


From: Michelle Konzack <linux4michelle(at)freenet(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: FW: Advanced search form
Date: 2005-12-15 16:07:05
Message-ID: 20051215160705.GA374@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Am 2005-12-07 18:16:43, schrieb Richard Huxton:

> Um - not sure what this has to do with PostgreSQL. You'll probably have
> more luck at one of the many PHP developer sites. I shouldn't be
> surprised if there was something available in the PEAR repository too.

I do not get the right QUERY for fulltext search in PGSQL

Greetings
Michelle

--
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack Apt. 917 ICQ #328449886
50, rue de Soultz MSM LinuxMichi
0033/3/88452356 67100 Strasbourg/France IRC #Debian (irc.icq.com)


From: Richard Huxton <dev(at)archonet(dot)com>
To: Michelle Konzack <linux4michelle(at)freenet(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: FW: Advanced search form
Date: 2005-12-15 17:16:16
Message-ID: 43A1A4E0.40404@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

Michelle Konzack wrote:
> Am 2005-12-07 18:16:43, schrieb Richard Huxton:
>
>> Um - not sure what this has to do with PostgreSQL. You'll probably have
>> more luck at one of the many PHP developer sites. I shouldn't be
>> surprised if there was something available in the PEAR repository too.
>
> I do not get the right QUERY for fulltext search in PGSQL

Ah - read up on "tsearch2" which provides text-searching.

--
Richard Huxton
Archonet Ltd