On Fri, Mar 24, 2006 at 07:06:19AM -0600, Jim C. Nasby wrote: > On Fri, Mar 24, 2006 at 02:01:29PM +0100, Ruben Rubio Rey wrote: > > mmm ... i have read in postgres documentation that null values on arrays > > are not supported ... > > Damn, you're right. Another reason I tend to stay away from them... 8.2 will support NULL array elements. http://archives.postgresql.org/pgsql-committers/2005-11/msg00385.php http://developer.postgresql.org/docs/postgres/arrays.html test=> SELECT '{1,2,NULL,3,4}'::integer[]; int4 ---------------- {1,2,NULL,3,4} (1 row) -- Michael Fuhr
