knut@wehrle.org wrote:
> 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.
Knut replied to the moderation notice to indicate that 9.4.8 fixed the
issue, and asked for a version log. Here's the git repository:
https://git.postgresql.org/gitweb/?p=postgresql.git
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services