Unnest discards rows with empty or null arrays - Mailing list pgsql-docs

From PG Doc comments form
Subject Unnest discards rows with empty or null arrays
Date
Msg-id 164000044713.26048.13078806558253708431@wrigleys.postgresql.org
Whole thread Raw
List 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 by date:

Previous
From: PG Doc comments form
Date:
Subject: The pg_stop_backup will return one row with three values.
Next
From: Laurenz Albe
Date:
Subject: Re: The pg_stop_backup will return one row with three values.