Re: row_to_json white space

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: row_to_json white space
Date: 2019-09-26 18:29:46
Message-ID: d776da60-06ed-3cbd-c596-acc70ccaed5e@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On 9/26/19 11:54 AM, Mark Lybarger wrote:
> select ROW_to_json(q) from (select 'foo        a   bar' as TEST) q;

Not here

postgres=# select ROW_to_json(q) from (select 'foo        a bar' as TEST) q;
          row_to_json
-------------------------------
 {"test":"foo        a   bar"}
(1 row)

postgres=# select version();
version
---------------------------------------------------------------------------------------------------------
 PostgreSQL 10.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5
20150623 (Red Hat 4.8.5-36), 64-bit
(1 row)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-09-26 18:49:10 Re: row_to_json white space
Previous Message Mark Lybarger 2019-09-26 17:54:55 row_to_json white space