Re: [GENERAL] Appending to multidimentional array.

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: [GENERAL] Appending to multidimentional array.
Дата
Msg-id CAKt_Zfu9bpHMQ-bP0uFG6TpdOLxLtp5E6ezHguFtVs7cp0OgnA@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Appending to multidimentional array.  (VENKTESH GUTTEDAR <venkteshguttedar@gmail.com>)
Список pgsql-general


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 по дате отправления:

Предыдущее
От: Achilleas Mantzios
Дата:
Сообщение: Re: [GENERAL] When updating row that has TOAST column, is the TOASTcolumn also reinserted ? Or just the oid to the value?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] When updating row that has TOAST column, is the TOAST column also reinserted ? Or just the oid to the value?