Ryan Wallace wrote:
> I am trying to perform a full text search for the word 'ksan (which
> starts with a quote). After much frustration and syntax errors I
> stumbled upon the following statement which seems to work:
>
> select *
> from items
> where to_tsvector(name) @@ to_tsquery(E'[\']ksan')
Hi all,
I am trying to perform a full text search for the word 'ksan (which starts with
a quote). After much frustration and syntax errors I stumbled upon the
following statement which seems to work:
select *
from items
where to_tsvector(name) @@ to_tsquery(E'[\']ksan')
I would like to know if