Re: BUG #7808: unnest doesn't handle nulls in array of composite types correctly - Mailing list pgsql-bugs

* joe@tanga.com (joe@tanga.com) wrote:
> My goal is to remove nulls from an array. The array could be an array of a
> composite type.

A much simpler case is:

=3D> create type xt as (a integer);
CREATE TYPE
=3D> select * from unnest(array[null::xt]);
ERROR:  function returning set of rows cannot return null value
=3D> select * from unnest(array[row(null)::xt]);
 a=20
---
 =20
(1 row)

    Thanks,

        Stephen