From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Mark Lybarger <mlybarger(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: row_to_json white space |
Date: | 2019-09-26 18:49:10 |
Message-ID: | 1a421353-66ef-018d-2f69-7b151ced5b82@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 9/26/19 10:54 AM, Mark Lybarger wrote:
> Hi,
>
> The row_to_json seems to strip white space:
>
> select ROW_to_json(q) from (select 'foo a bar' as TEST) q;
>
> any help on how to preserve?
Like Rob I do not see it:
test=# select version();
version
------------------------------------------------------------------------------------
PostgreSQL 11.5 on x86_64-pc-linux-gnu, compiled by gcc (SUSE Linux)
4.8.5, 64-bit
(1 row)
test=# select ROW_to_json(q) from (select 'foo a bar' as TEST) q;
row_to_json
-------------------------------
{"test":"foo a bar"}
(1 row)
Do you possibly have an overloaded function of the same name(ROW_to_json())?
>
> Thanks!
> -mark-
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-09-26 18:53:49 | Re: "Failed to connect to Postgres database" |
Previous Message | Rob Sargent | 2019-09-26 18:29:46 | Re: row_to_json white space |