On Jun 24, 2019, at 2:31 PM, Alex Magnum <magnum11200@gmail.com> wrote:Hi,I have two arrays which I need to combine based on the individual values;i could do a coalesce for each field but was wondering if there is an easier wayarray_a{a, null,c, d,null,f,null} primaryarray_b{null,2 ,null,4,5 ,6,null} secondary result {a, 2, c, d,5, f,null)Any advice would be appreciatedAre the inputs always of fixed dimensions eg. 1 by 7?
On Jun 24, 2019, at 2:31 PM, Alex Magnum <magnum11200@gmail.com> wrote:Hi,I have two arrays which I need to combine based on the individual values;i could do a coalesce for each field but was wondering if there is an easier wayarray_a{a, null,c, d,null,f,null} primaryarray_b{null,2 ,null,4,5 ,6,null} secondary result {a, 2, c, d,5, f,null)Any advice would be appreciated
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
