From: | Chris Travers <chris(dot)travers(at)gmail(dot)com> |
---|---|
To: | VENKTESH GUTTEDAR <venkteshguttedar(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:44:49 |
Message-ID: | CAKt_Zfu9bpHMQ-bP0uFG6TpdOLxLtp5E6ezHguFtVs7cp0OgnA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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}};
>
Forgot to reply all (in case someone searches the archives later):
Array_1 :== Array_1 || Array[Array_2]
>
>
>
> --
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2016-12-13 15:25:10 | Re: When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value? |
Previous 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? |