Re: Appending to multidimentional array.

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

In response to

Browse pgsql-general by date

  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?