| From: | VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com> |
|---|---|
| To: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
| Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Appending to multidimentional array. |
| Date: | 2016-12-13 14:24:06 |
| Message-ID: | CA+iwz4=jAYTFd9cdLR-geXT11XNqK05QgaaSjni1BHuYDnD07A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello Chris Travers.
Its working.
You saved my day.:)
Thanks a tons.
On Tue, Dec 13, 2016 at 9:18 AM, Chris Travers <chris(dot)travers(at)gmail(dot)com>
wrote:
> Array_1 :== Array_1 || Array[Array_2]
>
> I think
>
> On Tue, Dec 13, 2016 at 6:08 AM, VENKTESH GUTTEDAR <
> venkteshguttedar(at)gmail(dot)com> wrote:
>
>> Hello,
>>
>> Is there a way to append an array to a multidimentional array in
>> PL/PGSQL procedure?
>>
>> EG:
>> Array_1 = [][];
>> Array_2 = '{1,2,3,4,5}';
>>
>> Result should be :
>> Array_1 = {{1,2,3,4,5}};
>>
>>
>> --
>> Regards :
>> Venktesh Guttedar.
>>
>>
>
>
> --
> Best Wishes,
> Chris Travers
>
> Efficito: Hosted Accounting and ERP. Robust and Flexible. No vendor
> lock-in.
> http://www.efficito.com/learn_more
>
--
Regards :
Venktesh Guttedar.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Achilleas Mantzios | 2016-12-13 14:32:20 | Re: When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value? |
| Previous Message | Albe Laurenz | 2016-12-13 14:20:29 | Re: When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value? |