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
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. |