From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | eric(dot)mutta(at)gmail(dot)com |
Cc: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Bug in code sample in "8.15.5. Searching in Arrays" |
Date: | 2022-07-24 19:41:11 |
Message-ID: | 1738247.1658691671@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
PG Doc comments form <noreply(at)postgresql(dot)org> writes:
> The section on array searching here:
> https://www.postgresql.org/docs/current/arrays.html#ARRAYS-SEARCHING
> ...says "In addition, you can find rows where the array has all values equal
> to 10000 with:" and gives the following code example:
> SELECT * FROM sal_emp WHERE 10000 = ALL (pay_by_quarter);
Yeah ...
> ...however the docs for "ALL" over here:
> https://www.postgresql.org/docs/current/functions-comparisons.html#id-1.5.8.30.17
> ...explicitly say that "The result of ALL is “true” if all comparisons yield
> true (including the case where the array has zero elements)."
I don't see any conflict there.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Shinya Kato | 2022-07-25 03:29:54 | Re: Question about role attributes docs |
Previous Message | Tom Lane | 2022-07-24 19:39:17 | Re: Correction |