Postgres Pro
Downloads
Home   >   mailing lists

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

From Chris Travers
Subject Re: [GENERAL] Appending to multidimentional array.
Date
Msg-id CAKt_Zfu9bpHMQ-bP0uFG6TpdOLxLtp5E6ezHguFtVs7cp0OgnA@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Appending to multidimentional array.  (VENKTESH GUTTEDAR <venkteshguttedar@gmail.com>)
List pgsql-general
Tree view


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}};

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.

pgsql-general by date:

Previous
From: Achilleas Mantzios
Date:
Subject: Re: [GENERAL] When updating row that has TOAST column, is the TOASTcolumn also reinserted ? Or just the oid to the value?
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?