multidimensional array loading

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

Browse pgsql-novice by date

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