Horton

Re: Array performance

Michael Fuhr <mike@fuhr.org>

View thread
From: Michael Fuhr <mike@fuhr.org>
To: "Jim C. Nasby" <jnasby@pervasive.com>
Cc: Ruben Rubio Rey <ruben@rentalia.com>, pgsql-performance@postgresql.org
Date: 2006-03-24T13:32:53Z
Lists: pgsql-performance 
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