is the empty array representable in PostgreSQL, and is it distinguishable from NULL?
Yes, and yes.
regression=# select '{}'::int[]; int4 ------ {} (1 row)
regression=# select NULL::int[]; int4 ------
(1 row)
Since NULL array elements are not currently supported, attempting to construct an array with a NULL element results in NULL, not an empty array.
Joe
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]