Postgres Pro
Downloads
Home   >   mailing lists

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

From VENKTESH GUTTEDAR
Subject Re: [GENERAL] Appending to multidimentional array.
Date
Msg-id CA+iwz4=jAYTFd9cdLR-geXT11XNqK05QgaaSjni1BHuYDnD07A@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Appending to multidimentional array.  (Chris Travers <chris.travers@gmail.com>)
List pgsql-general
Tree view
Hello Chris Travers.

Its working.
You saved my day.:)

Thanks a tons.


On Tue, Dec 13, 2016 at 9:18 AM, Chris Travers <chris.travers@gmail.com> wrote:
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.



--
Regards :
Venktesh Guttedar.

pgsql-general by date:

Previous
From: Albe Laurenz
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: 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?