BUG #14213: bug in hstore_to_json_loose() function

From: knut(at)wehrle(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14213: bug in hstore_to_json_loose() function
Date: 2016-06-24 14:26:51
Message-ID: 20160624142651.17242.45918@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14213
Logged by: Knut Wehrle
Email address: knut(at)wehrle(dot)org
PostgreSQL version: 9.4.5
Operating system: Window 7 Pro SP1
Description:

I get an arrow with the following command:

select hstore_to_json_loose(hstore('"date"=>"2016-06-24"'))->>'date'

The problem is, that the function is not generating an ISO date string but a
mathematical formula: 2016 - 06 - 24 = 1986!

Probably this is the intended way to handle this kind of data, but then the
'->>' operator would be buggy.

regards knut

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-06-24 14:42:55 Re: BUG #14213: bug in hstore_to_json_loose() function
Previous Message Rafael Miani 2016-06-24 01:23:14 Erro ao iniciar o PGADMIN