Re: [SQL] Single Quote in tsquery

2008-08-06 Thread Alvaro Herrera
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')

[SQL] Single Quote in tsquery

2008-08-05 Thread Ryan Wallace
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