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

Re: Array performance

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Ruben Rubio Rey <ruben(at)rentalia(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Array performance
Date: 2006-03-24 13:06:19
Message-ID: 20060324130619.GF90527@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Mar 24, 2006 at 02:01:29PM +0100, Ruben Rubio Rey wrote:
> >http://www.varlena.com/GeneralBits/109.php might provide some useful
> >insights. I also recall seeing something about sum operators for arrays,
> >but I can't recall where.
> > 
> >
> I ll check it out, seems to be very useful
> Is faster create a function to sum the array?

There's been talk of having one, but I don't think any such thing
currently exists.

> >>AND array[20]<>0
> >>AND array[21]<>0
> >>...
> >>AND array[50]<>0
> >>AND array[51])<>0
> >>   
> >>
> >
> >Uhm... please don't tell me that you're using 0 in place of NULL...
> > 
> >
> 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...
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

Responses

pgsql-performance by date

Next:From: Michael FuhrDate: 2006-03-24 13:32:53
Subject: Re: Array performance
Previous:From: Ruben Rubio ReyDate: 2006-03-24 13:01:29
Subject: Re: Array performance

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