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