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:18:06
Message-ID: CAKt_Zft0kQsynQtzjuAAKBeFUYPAaXMy=bfTinc19JY9rajw5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next 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?
Previous Message VENKTESH GUTTEDAR 2016-12-13 14:08:27 Appending to multidimentional array.