Re: BUG #4446: Full text search cannot start with an apostrophe

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ryan Wallace" <rywall(at)interchange(dot)ubc(dot)ca>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4446: Full text search cannot start with an apostrophe
Date: 2008-10-01 13:08:31
Message-ID: 8078.1222866511@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Ryan Wallace" <rywall(at)interchange(dot)ubc(dot)ca> writes:
> A tsquery cannot be created if the first character is an apostrophe:

> SELECT * FROM text_search_vectors WHERE
> text_search_vector @@ to_tsquery('''ksan&panel')

That's not a bug, that's you not following the syntax rules for lexemes.
You'd need something like $$'''ksan' & panel$$ to represent a lexeme
with a quote in it.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Jen McCann 2008-10-02 20:42:01 BUG #4447: install failed to start; libintl3.dll was not found
Previous Message Ryan Wallace 2008-09-30 22:50:40 BUG #4446: Full text search cannot start with an apostrophe