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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
