The following bug has been logged online:
Bug reference: 2527
Logged by: Lance Rushing
Email address: lance_rushing(at)hotmail(dot)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