Re: row_to_json white space

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(dot)klaver(at)aklaver(dot)com
> <mailto:adrian(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com