Search Postgresql Archives

Re: row_to_json white space

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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)






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux