BUG #2527: Contrib - tsearch2 - ' as first char for in to_tsquery() - Mailing list pgsql-bugs

The following bug has been logged online:

Bug reference:      2527
Logged by:          Lance Rushing
Email address:      lance_rushing@hotmail.com
PostgreSQL version: 8.1.1
Operating system:   SuSE
Description:        Contrib - tsearch2 - ' as first char for in to_tsquery()
Details:

Not sure if this is a best place to report, but..

When using to_tsquery(TEXT,TEXT) I enounter an error when  the first
character is an apostrophe.

non-error example:
select to_tsquery('default'::text, 'o\'brien'::text);
  to_tsquery
---------------
 'o' & 'brien'

Example of error:
select to_tsquery('default'::text, '\'brien'::text);
ERROR:  syntax error