| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, tristan(dot)chambers(at)gmail(dot)com |
| Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Explicit or implicit? |
| Date: | 2021-11-22 03:37:55 |
| Message-ID: | a53b97bab996b7b12ed31d21184efdd91abe9f64.camel@cybertec.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
On Sun, 2021-11-21 at 12:50 -0500, Tom Lane wrote:
> PG Doc comments form <noreply(at)postgresql(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2021-11-22 12:06:59 | Triggers on underlying tables of updatable views |
| Previous Message | Tom Lane | 2021-11-21 17:50:48 | Re: Explicit or implicit? |