Re: [GENERAL] space taken by NULL values in array

2010-09-20 Thread Merlin Moncure
On Mon, Sep 20, 2010 at 4:12 AM, John R Pierce wrote: >  On 09/20/10 12:58 AM, Leonardo Francalanci wrote: >> >> Hi, >> >> >> since postgresql multidimensional arrays can't have different size per >> axis,... > > huh?  says what? > > i thought PG multidimensional arrays were just arrays of arrays,

Re: [GENERAL] space taken by NULL values in array

2010-09-20 Thread John R Pierce
On 09/20/10 1:24 AM, Leonardo Francalanci wrote: i thought PG multidimensional arrays were just arrays of arrays, and any dimension could be anything. from: http://www.postgresql.org/docs/8.4/static/arrays.html "Multidimensional arrays must have matching extents for each dimension. A misma

Re: [GENERAL] space taken by NULL values in array

2010-09-20 Thread Leonardo Francalanci
> i thought PG multidimensional arrays were just arrays of arrays, and any >dimension could be anything. from: http://www.postgresql.org/docs/8.4/static/arrays.html "Multidimensional arrays must have matching extents for each dimension. A mismatch causes an error" -- Sent via pgsql-g

Re: [GENERAL] space taken by NULL values in array

2010-09-20 Thread John R Pierce
On 09/20/10 12:58 AM, Leonardo Francalanci wrote: Hi, since postgresql multidimensional arrays can't have different size per axis,... huh? says what? i thought PG multidimensional arrays were just arrays of arrays, and any dimension could be anything. in fact, the docs for 8.4 state tha

[GENERAL] space taken by NULL values in array

2010-09-20 Thread Leonardo Francalanci
Hi, since postgresql multidimensional arrays can't have different size per axis, I was wondering what would happen in case I used an array of, say, 10x10 elements, where only 10x2 elements are filled and the rest are NULL. I guess the NULL elements take space (and I would have 80% of the space wa