Re: Stability of JSON textual representation - Mailing list pgsql-general

From Paul Jungwirth
Subject Re: Stability of JSON textual representation
Date
Msg-id CA+6hpa=9foqm5xGCHCajXJ0LceDLDZr-r2ZUYPf9QEtw7p+bbg@mail.gmail.com
Whole thread Raw
In response to Stability of JSON textual representation  (David Evans <david.evans@cantab.net>)
List pgsql-general
> I've noticed that when representing lists as JSON, Postgres 9.4 sometimes
> outputs spaces after commas, and other times does not.

Here is a similar test on 9.3:

# select '[1,2,3]'::json::text, '[1, 2, 3]'::json::text;
  text   |   text
---------+-----------
 [1,2,3] | [1, 2, 3]

It looks like even casting back and forth between text and json
preserves the text.

Paul

--
_________________________________
Pulchritudo splendor veritatis.


pgsql-general by date:

Previous
From: "George Weaver"
Date:
Subject: Re: "Ungroup" data for import into PostgreSQL
Next
From: Gavin Flower
Date:
Subject: Re: Stability of JSON textual representation