row_to_json white space

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)

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.klaver@aklaver.com

On 9/26/19 11:54 AM, Mark Lybarger wrote:

Ccing the list so folks know the problem is solved.

Problem is on my end.  My tool was showing the space removed and infact
it wasn't.  Copy paste from dbeaver to notepad++ shows the spaces are
preserved.

On Thu, Sep 26, 2019 at 2:49 PM Adrian Klaver <adrian.klaver@aklaver.com
<mailto:adrian.klaver@aklaver.com>> wrote:

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.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>

--
Adrian Klaver
adrian.klaver@aklaver.com