plpgsql : looping over multidimensional array : getting NULL for subdimension

From: Samba <saasira(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: plpgsql : looping over multidimensional array : getting NULL for subdimension
Date: 2010-12-01 15:03:09
Message-ID: AANLkTikR3fpd_OArX9-ZDry4S0RwXYA7zB+FhUhf8Awb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,

I'm trying to loop over a multidimensional array and find if any of
the elements in a sub-dimensional array are matching some known criteria but
facing issue with NULL for the sub arrays.

I have a data structure that looks like:

*some_array VARCHAR[][] :=
'{{samba,sarath,sreenivas},{samba,mukhesh,pavan}}'*;

I'm trying to assign the individual sub arrays to other array elements like:

other-array VARCHAR[];

other_array=some_array[1];

and I'm expecting to get '{samba,sarath,sreenivas}' for index 1 and
*{samba,mukhesh,pavan}
*for index 2;*
*however, I'm getting NULL.

Can some one explain the way I can assign subarrays to other array elements
plpgsql?

Thanks and Regards,
Samba

Responses

Browse pgsql-general by date

  From Date Subject
Next Message akp geek 2010-12-01 15:06:13 Grant command help -- postgres
Previous Message Vick Khera 2010-12-01 14:58:21 Re: Cannot start Postgres- FATAL: invalid cache id: 19