Re: Appending to multidimentional array.

From: VENKTESH GUTTEDAR <venkteshguttedar(at)gmail(dot)com>
To: Chris Travers <chris(dot)travers(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:24:06
Message-ID: CA+iwz4=jAYTFd9cdLR-geXT11XNqK05QgaaSjni1BHuYDnD07A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello Chris Travers.

Its working.
You saved my day.:)

Thanks a tons.

On Tue, Dec 13, 2016 at 9:18 AM, Chris Travers <chris(dot)travers(at)gmail(dot)com>
wrote:

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

--
Regards :
Venktesh Guttedar.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2016-12-13 14:32:20 Re: When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?
Previous 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?