diff options
| author | Andrew Dunstan <andrew@dunslane.net> | 2014-06-03 13:56:53 -0400 |
|---|---|---|
| committer | Andrew Dunstan <andrew@dunslane.net> | 2014-06-03 13:56:53 -0400 |
| commit | f30015b6d794c15d52abbb3df3a65081fbefb1ed (patch) | |
| tree | 6be9d4a73a40a628474f11f173252f16f72c6959 /doc/src | |
| parent | 2dfa15de5510b3c19ffb92b512c39d5440a07b1e (diff) | |
| download | postgresql-f30015b6d794c15d52abbb3df3a65081fbefb1ed.tar.gz postgresql-f30015b6d794c15d52abbb3df3a65081fbefb1ed.zip | |
Output timestamps in ISO 8601 format when rendering JSON.
Many JSON processors require timestamp strings in ISO 8601 format in
order to convert the strings. When converting a timestamp, with or
without timezone, to a JSON datum we therefore now use such a format
rather than the type's default text output, in functions such as
to_json().
This is a change in behaviour from 9.2 and 9.3, as noted in the release
notes.
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/release-9.4.sgml | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/doc/src/sgml/release-9.4.sgml b/doc/src/sgml/release-9.4.sgml index c0ead175d30..08307c8f667 100644 --- a/doc/src/sgml/release-9.4.sgml +++ b/doc/src/sgml/release-9.4.sgml @@ -164,6 +164,24 @@ <listitem> <para> + Values of type + <link linkend="datatype-datetime"><type>timestamp</></link> and + <link linkend="datatype-datetime"><type>timestamptz</></link> are now + rendered in a string format compliant with ISO 8601 rather than the + default output format when converting to or used in + <link linkend="datatype-json"><type>JSON</type></link>. + (Andrew Dunstan) + </para> + + <para> + Previously these were rendered in the default text output format + for the type, but many JSON processors require timestamps in ISO 8601 + format. + </para> + </listitem> + + <listitem> + <para> Rename <link linkend="SQL-EXPLAIN"><command>EXPLAIN ANALYZE</></link>'s "total runtime" output to "execution time" (Tom Lane) |