From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
Cc: | Dagfinn Ilmari Mannsåker <ilmari(at)ilmari(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: is somewhere documented x LIKE ANY(ARRAY)? |
Date: | 2020-03-23 14:38:23 |
Message-ID: | 29723.1584974303@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> po 23. 3. 2020 v 13:54 odesílatel Dagfinn Ilmari Mannsåker <
> ilmari(at)ilmari(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2020-03-23 14:45:43 | Re: ASLR support for Postgres12 |
Previous Message | Fujii Masao | 2020-03-23 14:36:35 | Re: replay pause vs. standby promotion |