Re: Simplifying Text Search

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Simon Riggs" <simon(at)2ndquadrant(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 20:59:17
Message-ID: 162867790711121259o40ece47etdcfbc0f1b7513c3a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

look to standard, please. SQL/MM has part - full text.

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.

So,it can be:

SELECT ..
FROM x.contains(y);

It's well readable and elegant too.

Regards
Pavel Stehule

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2007-11-12 20:59:40 Re: Simplifying Text Search
Previous Message Simon Riggs 2007-11-12 20:47:56 Re: Simplifying Text Search