Null as array element

From: Amin Abdulghani <amin(at)quantiva(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Null as array element
Date: 2001-07-24 19:14:15
Message-ID: 5.1.0.14.0.20010724150024.00abfeb8@mail.quantiva.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have recently been playing around with the array data types. My
objective is to use Postgress to store sparse arrays.
One of the things that I noticed is that I can't store null as a value
for an element of an array. So for example if I have a column A of type
text[] and the values for this column are set to {"val1",null,"val2",,"val3"},
then I would have A[1]="val1", A[2]="null", A[3]="val2", A4="" (empty string),
A[5]="val3". What I am guessing from this is that each element is
actually taking up space. I am wondering whether there is a better way
to approach this to store sparse arrays.

Thanks..
Amin

Browse pgsql-general by date

  From Date Subject
Next Message Lee Harr 2001-07-24 19:26:07 Re: pqReadData() -- backend closed the channel unexpectedly.
Previous Message GH 2001-07-24 19:03:50 Re: Postmaster won't start.