Message-ID: <a53b97bab996b7b12ed31d21184efdd91abe9f64.camel@cybertec.at>
Subject: Re: Explicit or implicit?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Tom Lane <tgl@sss.pgh.pa.us>, tristan.chambers@gmail.com
Cc: pgsql-docs@lists.postgresql.org
Date: Mon, 22 Nov 2021 04:37:55 +0100
In-Reply-To: <3468877.1637517048@sss.pgh.pa.us>
References: 
	<163742474559.26193.12547875443867026853@wrigleys.postgresql.org>
	 <3468877.1637517048@sss.pgh.pa.us>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/a53b97bab996b7b12ed31d21184efdd91abe9f64.camel%40cybertec.at>
Precedence: bulk

On Sun, 2021-11-21 at 12:50 -0500, Tom Lane wrote:
> PG Doc comments form <noreply@postgresql.org> writes:
> > "The @@ operator also supports text input, allowing explicit conversion of a
> > text string to tsvector or tsquery to be skipped in simple cases."I believe
> > that the text is saying implicit, but uses the word "explicit" instead. Is
> > this a typo? Thanks.
> 
> I think it's intended.  The point is that instead of, say,
> 
>         tsvector_column @@ 'query here'::tsquery
> 
> you could just write
> 
>         tsvector_column @@ 'query here'

Right.  You can skip the explicit conversion of adding a type cast.

Yours,
Laurenz Albe