From: | "David Monarchi" <david(dot)e(dot)monarchi(at)gmail(dot)com> |
---|---|
To: | pgsql-novice(at)postgresql(dot)org |
Subject: | multidimensional array loading |
Date: | 2007-06-04 22:41:06 |
Message-ID: | eea51fdb0706041541g91383e8qfe119b41d75812fe@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello
I have data in which one of the fields has the following structure for a
single value in the table
'{ { w, {1,2}}, {x, {11,22}},{y, {44,55}},{z, {77,22}} }'
The number of "rows" in the field (i.e., w,x,y z...) will be unknown, but
for each one there will always be a pair of associated values.
I've been trying to figure out how to insert the above example, but so far
have not be able to solve the puzzle. The field is defined as a text array
with two dimensions. I've also in desperation tried three dimensions but to
no avail.
I know that I can simply use
'{ {w, 1, 2}, {x, 11, 22},{y, 44, 55},{z, 77, 22} }'
but I would like to keep the two numbers as a logical unit.
Any assistance would be greatly appreciated.
Thank you.
david
From | Date | Subject | |
---|---|---|---|
Next Message | Ashish Karalkar | 2007-06-05 06:04:53 | Assigning Password to New created user |
Previous Message | Andrej Ricnik-Bay | 2007-06-04 21:06:49 | Re: Laptop Mobo Dead... |