Horton

Thread

Commits

  1. Doc: explain that LIKE et al can be used in ANY (sub-select) etc.

  1. is somewhere documented x LIKE ANY(ARRAY)?

    Pavel Stehule <pavel.stehule@gmail.com> — 2020-03-23T12:43:28Z

    Hi

I try to search notice about it, to get info about release date of this
feature, but I cannot find it.

Regards

Pavel

  2. Re: is somewhere documented x LIKE ANY(ARRAY)?

    Dagfinn Ilmari Mannsåker <ilmari@ilmari.org> — 2020-03-23T12:54:31Z

    Pavel Stehule <pavel.stehule@gmail.com> writes:

> Hi
>
> I try to search notice about it, to get info about release date of this
> feature, but I cannot find it.

It's documented in
https://www.postgresql.org/docs/current/functions-comparisons.html, and
has been around since at least 7.4.

> Regards
>
> Pavel

- ilmari
-- 
- Twitter seems more influential [than blogs] in the 'gets reported in
  the mainstream press' sense at least.               - Matt McLeod
- That'd be because the content of a tweet is easier to condense down
  to a mainstream media article.                      - Calle Dybedahl

  3. Re: is somewhere documented x LIKE ANY(ARRAY)?

    Pavel Stehule <pavel.stehule@gmail.com> — 2020-03-23T13:01:04Z

    po 23. 3. 2020 v 13:54 odesílatel Dagfinn Ilmari Mannsåker <
ilmari@ilmari.org> napsal:

> Pavel Stehule <pavel.stehule@gmail.com> writes:
>
> > Hi
> >
> > I try to search notice about it, to get info about release date of this
> > feature, but I cannot find it.
>
> It's documented in
> https://www.postgresql.org/docs/current/functions-comparisons.html, and
> has been around since at least 7.4.
>

My customer reports some issues on Postgres 9.3.



> > Regards
> >
> > Pavel
>
> - ilmari
> --
> - Twitter seems more influential [than blogs] in the 'gets reported in
>   the mainstream press' sense at least.               - Matt McLeod
> - That'd be because the content of a tweet is easier to condense down
>   to a mainstream media article.                      - Calle Dybedahl
>

  4. Re: is somewhere documented x LIKE ANY(ARRAY)?

    Tom Lane <tgl@sss.pgh.pa.us> — 2020-03-23T14:38:23Z

    Pavel Stehule <pavel.stehule@gmail.com> writes:
> po 23. 3. 2020 v 13:54 odesílatel Dagfinn Ilmari Mannsåker <
> ilmari@ilmari.org> napsal:
>> It's documented in
>> https://www.postgresql.org/docs/current/functions-comparisons.html, and
>> has been around since at least 7.4.

Well, to be fair, we don't really say anywhere that LIKE acts enough
like a plain operator to be used in this syntax.  And the underlying
code is the subquery_Op production in gram.y, which is specific to
this syntax, so I'm not sure offhand to what extent LIKE acts like
an operator for other corner cases.

> My customer reports some issues on Postgres 9.3.

Doesn't look to me like subquery_Op has changed much since 2004,
so you'd really need to be more specific.

			regards, tom lane