websearch_to_tsquery() and apostrophe inside double quotes

[Alastair McKinley <a.mckinley@xxxxxxxxxxxxxxxxxxxx>]

Hi all,

I am a little confused about what us being generated by websearch_to_tsquery() in the case of an apostrophe inside double quotes.

Here is an example of searching for a name containing an apostrophe.

The following works as expected:

select to_tsvector('peter o''toole') @@ websearch_to_tsquery('peter o''toole');

 ?column?

----------

 t

(1 row)

When the name is in double quotes, the search fails:

select to_tsvector('peter o''toole') @@ websearch_to_tsquery('"peter o''toole"');

 ?column?

----------

 f

(1 row)

In the first case, websearch_to_tsquery() returns:

select websearch_to_tsquery('peter o''toole');

  websearch_to_tsquery  

------------------------

 'peter' & 'o' & 'tool'

(1 row)

which makes sense to me.

In the second case websearch_to_tsquery() returns something that I can't quite understand:

select websearch_to_tsquery('"peter o''toole"');

     websearch_to_tsquery    

------------------------------

 'peter' <-> ( 'o' & 'tool' )

(1 row)

I am not quite sure what text this will actually match?

Best regards,

Alastair