* joe(at)tanga(dot)com (joe(at)tanga(dot)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:
=> create type xt as (a integer);
CREATE TYPE
=> select * from unnest(array[null::xt]);
ERROR: function returning set of rows cannot return null value
=> select * from unnest(array[row(null)::xt]);
a
---
(1 row)
Thanks,
Stephen