Postgres Pro
Downloads
Home   >   mailing lists

Re: MAP syntax for arrays - Mailing list pgsql-hackers

From Ildar Musin
Subject Re: MAP syntax for arrays
Date
Msg-id 75a78e3e-ff04-d7bc-fc36-b362eac911c7@postgrespro.ru
Whole thread Raw
In response to Re: MAP syntax for arrays  (Ildar Musin <i.musin@postgrespro.ru>)
Responses Re: MAP syntax for arrays  (Chapman Flack <chap@anastigmatix.net>)
List pgsql-hackers
Tree view 
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.musin@postgrespro.ru

pgsql-hackers by date:

Previous
From: Ildar Musin
Date:
Subject: Re: MAP syntax for arrays
Next
From: Robert Haas
Date:
Subject: Re: [HACKERS] Parallel Append implementation