From: | Samba <saasira(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stalled post to pgsql-general |
Date: | 2010-12-01 15:10:11 |
Message-ID: | AANLkTim=kT=fOuHv=grHVyJ_4p=V_K992-BKTbySyHFV@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
REPOST!
On Wed, Dec 1, 2010 at 8:34 PM, <pgsql-general-owner(at)postgresql(dot)org> wrote:
> Your message to pgsql-general has been delayed, and requires the approval
> of the moderators, for the following reason(s):
>
> The author (Samba <saasira(at)gmail(dot)com>)
> is not a member of any of the restrict_post groups.
>
> If you do not wish the message to be posted, or have other concerns,
> please send a message to the list owners at the following address:
> pgsql-general-owner(at)postgresql(dot)org
>
>
> ---------- Forwarded message ----------
> From: Samba <saasira(at)gmail(dot)com>
> To: pgsql-general(at)postgresql(dot)org
> Date: Wed, 1 Dec 2010 20:33:09 +0530
> Subject: plpgsql : looping over multidimensional array : getting NULL for
> subdimension
> 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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | mabra | 2010-12-01 15:16:31 | Looking for auto starting procedures |
Previous Message | akp geek | 2010-12-01 15:06:13 | Grant command help -- postgres |