Unnest discards rows with empty or null arrays

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Unnest discards rows with empty or null arrays
Дата
Msg-id 164000044713.26048.13078806558253708431@wrigleys.postgresql.org
обсуждение исходный текст
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/14/functions-srf.html
Description:

https://www.postgresql.org/message-id/17340-74d17bbe94cb4190%40postgresql.org

This behaviour is unexpected from an external perspective but after speaking
with depesz I can see the exact edge case it's guarding against.
Returning rows with null values when the function does not return anything,
would be natural except for the fact that null is a valid return value by
itself.

Discarding the row is preferential to giving ambiguous answers since it's a
very clear answer.

I can't see it mentioned anywhere in the documentation though.

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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: The pg_stop_backup will return one row with three values.
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: The pg_stop_backup will return one row with three values.