Re: BUG #13937: 'src' -> jsonb_each() -> jsonb_object() -> 'dst' does not recreate 'src' as valid jsonb

From: Xtra Coder <xtracoder(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #13937: 'src' -> jsonb_each() -> jsonb_object() -> 'dst' does not recreate 'src' as valid jsonb
Date: 2016-02-09 18:45:03
Message-ID: CAL2enjLZj21rb6qsJPVJYpNxF-A_pTt+aWKpkf1yYj+tYSRiSg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Re: I think your original coding is kinda broken anyway; there's no
hard guarantee
that those two array sub-selects will give results in the same order.
----------------------------------

Order of the keys is, of course, of no point here (and is not relevant for
normal JSON). Conversion to string is just for 'representational/debugging'
purposes.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2016-02-10 00:07:57 Re: BUG #13936: jsonb_object() -> ERROR: unknown type of jsonb container
Previous Message Xtra Coder 2016-02-09 18:42:15 Re: BUG #13937: 'src' -> jsonb_each() -> jsonb_object() -> 'dst' does not recreate 'src' as valid jsonb