]> granicus.if.org Git - postgresql/commit
Use EncodeDateTime instead of to_char to render JSON timestamps.
authorAndrew Dunstan <andrew@dunslane.net>
Tue, 3 Jun 2014 22:26:47 +0000 (18:26 -0400)
committerAndrew Dunstan <andrew@dunslane.net>
Tue, 3 Jun 2014 22:26:47 +0000 (18:26 -0400)
commitab14a73a6ca5cc4750f0e00a48bdc25a2293034a
treef2b0ad98b0346ed6824798052d752d9bd48e64ba
parent0ad1a816320a2b539a51628e2a0b1e83ff096b1d
Use EncodeDateTime instead of to_char to render JSON timestamps.

Per gripe from Peter Eisentraut and Tom Lane.

The output is slightly different, but still ISO 8601 compliant: to_char
doesn't output the minutes when time zone offset is an integer number of
hours, while EncodeDateTime outputs ":00".

The code is slightly adapted from code in xml.c
src/backend/utils/adt/json.c
src/test/regress/expected/json.out
src/test/regress/expected/json_1.out