> -----Original Message----- > From: pgsql-sql-ow...@postgresql.org [mailto:pgsql-sql- > ow...@postgresql.org] On Behalf Of mephysto > Sent: Thursday, September 27, 2012 6:12 AM > To: pgsql-sql@postgresql.org > Subject: [SQL] Help in accessing array > > 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
IIRC You cannot de-dimension an array (aside from the special-case single dimension, 1 value, case). You will need to unnest the array into components, filter those components, then go from there. Each, "unnest(array)" call explodes one dimension. Consider wraping things in a function to make the code cleaner. David J. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql