Re: Simplifying Text Search

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Simplifying Text Search
Date: 2007-11-12 21:07:37
Message-ID: 1194901657.2644.240.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 2007-11-12 at 21:59 +0100, Pavel Stehule wrote:

> SELECT docno
> FROM information
> WHERE document.CONTAINS
> ('STEMMED FORM OF "standard"
> IN SAME PARAGRAPH AS
> SOUNDS LIKE "sequel"') = 1
>
> it's little bit baroque, It's sample of method.

Seems thats the way Oracle does it too.

The SQLServer syntax is

WHERE contains(text_column, search_query)

which seems marginally better.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2007-11-12 21:08:33 Re: Simplifying Text Search
Previous Message Martijn van Oosterhout 2007-11-12 21:03:11 Re: Simplifying Text Search