Re: Add jsonb_compact(...) for whitespace-free jsonb to text

From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: "Shulgin, Oleksandr" <oleksandr(dot)shulgin(at)zalando(dot)de>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>, "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Ryan Pedela <rpedela(at)datalanche(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Sehrope Sarkuni <sehrope(at)jackdb(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Add jsonb_compact(...) for whitespace-free jsonb to text
Date: 2016-05-02 14:04:48
Message-ID: 57275E80.8070601@dunslane.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 05/02/2016 04:56 AM, Shulgin, Oleksandr wrote:
> On Sun, May 1, 2016 at 3:22 AM, Andrew Dunstan <andrew(at)dunslane(dot)net
> <mailto:andrew(at)dunslane(dot)net>> wrote:
>
>
> On 04/29/2016 06:11 PM, Merlin Moncure wrote:
>
> This is a simple matter of removing spaces in the occasional C
> string
> literal in the serialization routines and adding a json_pretty
> function.
>
>
> I spent a few hours on this. See
> <https://bitbucket.org/adunstan/pgdevel/commits/branch/jsonformat>
> for WIP - there are three commits. No regression tests yet for the
> two new functions (json_squash and json_pretty), Otherwise fairly
> complete. Removing whitespace generation was pretty simple for
> both json and jsonb.
>
>
> Looks good, thank you!
>
> It would make sense IMO to rename FormatState's `indent' field as
> `pretty': it's being used to add whitespace between the punctuation,
> not only at start of a line. I'd also move the "if (indent)" check
> out of add_indent(): just don't call it if no indent is needed.
>
> I'll try to play with the patch to produce some regression tests for
> the new functions.
>
>

It was done the way it was to be as consistent as possible with how it's
done for jsonb (c.f. jsonb.c:JsonbToCStringWorker and jsonb.c::add_indent).

cheers

andrew

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2016-05-02 14:07:50 Re: 9.6 and fsync=off
Previous Message Tom Lane 2016-05-02 14:00:18 Re: Refactor pg_dump as a library?