Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp - Mailing list pgsql-bugs

From Степан Перлов
Subject Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp
Date
Msg-id CAEtu67+ek-WYgxTvCNdgUtOmVOOpxnhhRwAGFqt_iYP32QZQ=A@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view


On Mon, Oct 19, 2015 at 5:25 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Mon, Oct 19, 2015 at 9:00 AM, <stepanperlov@gmail.com> wrote:
The following bug has been logged on the website:

Bug reference:      13687
Logged by:          Stepan
Email address:      stepanperlov@gmail.com
PostgreSQL version: 9.4.5
Operating system:   Ubuntu 14.04.1 LTS
Description:

SELECT row_to_json(t)
  FROM (SELECT '-infinity'::timestamptz) t

​What do you see happening and what do you think should happen (and why)?

David J.
​
 
Sorry, forget add output:

SELECT row_to_json(t) FROM (SELECT '-infinity'::timestamptz AS time) t

OUT: '{"time":"infinity"}'
MUST: '{"time":"-infinity"}'

In postgresql 9.3 it returns '-infinity'.
Problem with cast timestamp to string in row_to_json function.

SELECT row_to_json(t2) FROM  (SELECT time::text FROM (SELECT '-infinity'::timestamptz AS time) t) t2
returns '{"time":"-infinity"}'

pgsql-bugs by date:

Previous
From: rucsoftsec@163.com
Date:
Subject: BUG #13688: lack of return value in r_mark_regions()
Next
From: "David G. Johnston"
Date:
Subject: Re: BUG #13687: bug in row_to_json function with '-infinity' timestamp