Thank you - On Wed, Mar 14, 2018 at 8:41 PM, Ivan E. Panchenko < i.panche...@postgrespro.ru> 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='play' > 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='play' words(> order by played desc limit 5 words(> ) y; string_agg ---------------- А Н Т Щ П (1 row)
