pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: barbiomalefico@gmail.com
To: pgsql-docs@postgresql.org
Subject: followed by example doesn't work
Date: Sun, 03 Dec 2017 09:35:46 +0000
Message-ID: <20171203093546.27110.95117@wrigleys.postgresql.org> (raw)

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/textsearch-intro.html
Description:

I copied the text in the followed by example: SELECT to_tsvector(&#39;fatal
error&#39;) @@ to_tsquery(&#39;fatal &lt;-&gt; error&#39;); 
but it will always goes in error: ERROR:  syntax error in tsquery: &quot;fatal
&lt;-&gt; error&quot;
SQL state: 42601
I find two ways to solve the problem:
1. remove the space inside the to_tsquery string to obtain &#39;fatal&lt;-&gt;error&#39;
2. use plainto_tsquery instead of to_tsquery.


view thread (6+ messages)  latest in thread

Message-ID: <20171203093546.27110.95117@wrigleys.postgresql.org>
Permalink:  ../20171203093546.27110.95117@wrigleys.postgresql.org/
Also on:    postgresql.org/message-id/20171203093546.27110.95117@wrigleys.postgresql.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-docs@postgresql.org
  Cc: barbiomalefico@gmail.com
  Subject: Re: followed by example doesn't work
  In-Reply-To: <20171203093546.27110.95117@wrigleys.postgresql.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox