Re: 9.3: bug related to json

From: David G Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 9.3: bug related to json
Date: 2015-02-25 06:22:58
Message-ID: 1424845378831-5839310.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Torsten Förtsch wrote
> cross join lateral (
> select string_agg(', ', syms.sym ->> 'x') as xx
> from json_array_elements(t.el -> 's')
> syms(sym)

I'm doubting you intended to join a bunch of commas using the field value as
the delimiter...methinks your got the argument order reversed for
string_agg.

David J.

--
View this message in context: http://postgresql.nabble.com/9-3-bug-related-to-json-tp5839261p5839310.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G Johnston 2015-02-25 06:34:33 Re: 9.3: bug related to json
Previous Message Stephen Frost 2015-02-25 02:51:19 Re: Row-level Security vs Application-level authz