Re: Explicit or implicit? - Mailing list pgsql-docs

From Laurenz Albe
Subject Re: Explicit or implicit?
Date
Msg-id a53b97bab996b7b12ed31d21184efdd91abe9f64.camel@cybertec.at
Whole thread Raw
In response to Re: Explicit or implicit?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs
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




pgsql-docs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Explicit or implicit?
Next
From: PG Doc comments form
Date:
Subject: Triggers on underlying tables of updatable views