Skip site navigation (1) Skip section navigation (2)

Re: Array performance

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: Ruben Rubio Rey <ruben(at)rentalia(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Array performance
Date: 2006-03-24 13:32:53
Message-ID: (view raw, whole thread or download thread mbox)
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.

test=> SELECT '{1,2,NULL,3,4}'::integer[];
(1 row)

Michael Fuhr

In response to


pgsql-performance by date

Next:From: Alvaro HerreraDate: 2006-03-24 13:47:20
Subject: Re: WAL logging of SELECT ... INTO command
Previous:From: Jim C. NasbyDate: 2006-03-24 13:06:19
Subject: Re: Array performance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group