Re: Extract elements from JSON array and return them as concatenated string

[Alexander Farber <alexander.farber@xxxxxxxxx>]

Thank you -

On Wed, Mar 14, 2018 at 8:41 PM, Ivan E. Panchenko <i.panchenko@xxxxxxxxxxxxxx> wrote:

Yes, here x is the alias for the record, not for the json field. So you need to write the query like 

select string_agg(x->>'letter', ' ')
from (
   select jsonb_array_elements(tiles) x
   from words_moves
   where gid=656 and action=""
   order by played desc limit 5
) y;

This has worked perfectly:

words=> select string_agg(x->>'letter', ' ') 

words-> from (

words(>    select jsonb_array_elements(tiles) x 

words(>    from words_moves

words(>    where gid=656 and action="">

words(>    order by played desc limit 5

words(> ) y;

   string_agg   

----------------

 А Н Т Щ П

(1 row)