tsearch2: how to plainto_tsquery() with "|" - Mailing list pgsql-general

From John Smith
Subject tsearch2: how to plainto_tsquery() with "|"
Date
Msg-id CAMZ8qd9ycQoHGtPodJU9X6F8YDdKr43yrKiQw89+V4GNhujq8w@mail.gmail.com
Whole thread Raw
Responses Re: tsearch2: how to plainto_tsquery() with "|"
List pgsql-general
i can run "...@@ to_tsquery('cat | dog')".

but if i run "...@@ to_tsquery('cat dog')", it gives me a syntax error (#42601).

so i run "...@@ plainto_tsquery('cat dog')".

but then i can't run "...@@ plainto_tsquery('cat | dog')".

can you help before i give up on tsearch2?

thks, jzs

http://postgresql.1045698.n5.nabble.com/tsearch2-plainto-tsquery-with-OR-td1885955.html
http://www.postgresql.org/docs/9.3/static/textsearch.html


pgsql-general by date:

Previous
From: Joseph Kregloh
Date:
Subject: Re: Upgrading from 9.2 to 9.3 causes performance degradation
Next
From: Tom Lane
Date:
Subject: Re: tsearch2: how to plainto_tsquery() with "|"