Questions about setting an array element value outside of the update

Поиск
Список
Период
Сортировка
Искать
От
Maxim Boguk
Тема
Questions about setting an array element value outside of the update
Дата
Msg-id
CAK-MWwQJjimCLgSsAKpL=n7jGT2p5WzTfBPD6HSmc63NfjbqqQ@mail.gmail.com
Список
Дерево обсуждения
Questions about setting an array element value outside of the update Maxim Boguk <maxim.boguk@gmail.com>
Re: Questions about setting an array element value outside of the update David Johnston <polobo@yahoo.com>
Re: Questions about setting an array element value outside of the update Tom Lane <tgl@sss.pgh.pa.us>
Lets say i have subquery which produce array[], position and new_value

Is here less clumsy way to set  array[position] to the new_value (not update but just change an element inside an array) than:

SELECT
        _array[1:pos-1]
        ||newval
        ||_array[_pos+1:array_length(_array, 1)]
FROM
(
    SELECT _array,
                   pos,
                   newval
     FROM
                   some_colmplicated_logic
);

The:
        _array[1:pos-1]
        ||newval
        ||_array[_pos+1:array_length(_array, 1)]
part is very clumsy for my eyes.

PS: that is just small part of the complicated WITH RECURSIVE iterator in real task.

--
Maxim Boguk
Senior Postgresql DBA.

В списке pgsql-general по дате отправления
От: Tom Lane
Дата:
От: David Johnston
Дата:
FAQ