Re: MAP syntax for arrays

[Ildar Musin]

On 08.05.2018 15:49, Ildar Musin wrote:

select map (pow(x, 2) - 1 for x in array[1,2,3]);

Sorry, the example should be:

select map (pow(2, x) - 1 for x in array[1,2,3,4,5]);
   ?column?
---------------
 {1,3,7,15,31}
(1 row)

--
Ildar Musin
i.mu...@postgrespro.ru