Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: tsearch2: how to plainto_tsquery() with "|"
Date
Msg-id 30669.1395780394@sss.pgh.pa.us
Whole thread Raw
In response to tsearch2: how to plainto_tsquery() with "|"  (John Smith <jayzee.smith@gmail.com>)
Responses Re: tsearch2: how to plainto_tsquery() with "|"  (John Smith <jayzee.smith@gmail.com>)
List pgsql-general
Tree view 
John Smith <jayzee.smith@gmail.com> writes:
> 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')".

Yeah ... that's pretty much exactly the point of having two different
functions.  to_tsquery() honors boolean operators in the query, the other
doesn't.

If this doesn't fit your notions of a reasonable API, maybe you could
create your own preprocessing function.

            regards, tom lane

pgsql-general by date:

Previous
From: John Smith
Date:
Subject: tsearch2: how to plainto_tsquery() with "|"
Next
From: Steven Schlansker
Date:
Subject: Trimming transaction logs after extended WAL archive failures