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: 20060324133252.GA22688@winnie.fuhr.org (view raw or flat)
Thread:
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

In response to

Responses

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-2014 The PostgreSQL Global Development Group