Appending to multidimentional array.

Started by VENKTESH GUTTEDARover 9 years ago4 messagesgeneral
Jump to latest
#1VENKTESH GUTTEDAR
venkteshguttedar@gmail.com

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.

#2Chris Travers
chris.travers@gmail.com
In reply to: VENKTESH GUTTEDAR (#1)
Re: Appending to multidimentional array.

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

#3VENKTESH GUTTEDAR
venkteshguttedar@gmail.com
In reply to: Chris Travers (#2)
Re: Appending to multidimentional array.

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.
http://www.efficito.com/learn_more

--
Regards :
Venktesh Guttedar.

#4Chris Travers
chris.travers@gmail.com
In reply to: VENKTESH GUTTEDAR (#1)
Re: Appending to multidimentional array.

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.
http://www.efficito.com/learn_more