Help in accessing array - Mailing list pgsql-sql

From mephysto
Subject Help in accessing array
Date
Msg-id 1348740741516-5725666.post@n5.nabble.com
Whole thread Raw
Responses Re: Help in accessing array  ("David Johnston" <polobo@yahoo.com>)
List pgsql-sql
Hi to everyone,
I have a little problem to retrieve data from multidimensional array. For
example, if I have this array

foo[][] = {{5,3},{2,2}}

how can I retrieve one of two internal array (for example I would to
retrieve {5,3}?

I tried foo[1:1] but the result is {{5,3}}, not {5,3}.

Is a method to achieve my goal?

Thanks in advance.

Mephysto



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Help-in-accessing-array-tp5725666.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.



pgsql-sql by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: [noob] How to optimize this double pivot query?
Next
From: Samuel Gendler
Date:
Subject: Re: [noob] How to optimize this double pivot query?