Help in accessing array

From: mephysto <mephystoonhell(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Help in accessing array
Date: 2012-09-27 10:12:21
Message-ID: 1348740741516-5725666.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Matthias Nagel 2012-09-29 10:49:18 Reuse temporary calculation results in an SQL update query
Previous Message Jasen Betts 2012-09-26 12:50:53 Re: HOw to convert unicode to string