Hi all,

How can I create a following query?

SELECT title FROM pgweb WHERE fts @@ to_tsquery('friend');

I'm wondering how to achieve an @@ operator.

Kind Regards, MiloszeS

What does this operator do?

It searches a vector for a specified elements. Something like Contains.

Ex:

The fts column contains a collection of words:

1) "LLBLGen", "Pro" 2) "LLBLGen", "ORM"

If we declare a following clause:

WHERE fts @@ to_tsquery('LLBLGen');

It'll search all rows containing LLBLGen word.

It's only my ween about the operator meaning - hope I'm not wrong . More info can be found in the documentation:

http://204.145.120.225/docs/8.4/interactive/textsearch-tables.html#TEXTSEARCH-TABLES-INDEX

Regards, MiloszeS

You will need to create a custom predicate for this. You can start by deriving from FieldLikePredicate and override the ToQueryText method to produce @@ instead of LIKE.

Ok, works perfect.

Thanks for a help. Regards, MiloszeS