Re: Bug in code sample in "8.15.5. Searching in Arrays"

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug in code sample in "8.15.5. Searching in Arrays"
Дата
Msg-id 1738247.1658691671@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Bug in code sample in "8.15.5. Searching in Arrays"  (PG Doc comments form <noreply@postgresql.org>)
Список pgsql-docs
PG Doc comments form <noreply@postgresql.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



В списке pgsql-docs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Correction
Следующее
От: Shinya Kato
Дата:
Сообщение: Re: Question about role attributes docs