Sent: 10 October 2019 14:35
To: Alastair McKinley
Cc: pgsql-general@lists.postgresql.org ;
teo...@sigaev.ru
Subject: Re: websearch_to_tsquery() and apostrophe inside double quotes
Alastair McKinley writes:
> I am a little confused about what us being generated by
> websearch_to_tsquery(
Alastair McKinley writes:
> I am a little confused about what us being generated by
> websearch_to_tsquery() in the case of an apostrophe inside double quotes.
> ...
> select websearch_to_tsquery('"peter o''toole"');
> websearch_to_tsquery
> --
> 'peter' <-> ( '
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_t
