* j...@tanga.com (j...@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:
=> 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
signature.asc
Description: Digital signature
