Home > mailing lists

Re: [GENERAL] Appending to multidimentional array. - Mailing list pgsql-general

From	Chris Travers
Subject	Re: [GENERAL] Appending to multidimentional array.
Date	December 13, 2016 20:18:06
Msg-id	CAKt_Zft0kQsynQtzjuAAKBeFUYPAaXMy=bfTinc19JY9rajw5A@mail.gmail.com Whole thread Raw
In response to	[GENERAL] Appending to multidimentional array. (VENKTESH GUTTEDAR <venkteshguttedar@gmail.com>)
Responses	Re: [GENERAL] Appending to multidimentional array.
List	pgsql-general

Tree view

Array_1 :== Array_1 || Array[Array_2]

I think

On Tue, Dec 13, 2016 at 6:08 AM, VENKTESH GUTTEDAR <venkteshguttedar@gmail.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

pgsql-general by date:

From: VENKTESH GUTTEDAR
Date: 13 December 2016, 20:08:27
Subject: [GENERAL] Appending to multidimentional array.

From: Albe Laurenz
Date: 13 December 2016, 20:20:29
Subject: Re: [GENERAL] When updating row that has TOAST column, is the TOASTcolumn also reinserted ? Or just the oid to the value?

Re: [GENERAL] Appending to multidimentional array. - Mailing list pgsql-general

Previous

Next