aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew Dunstan <andrew@dunslane.net>2015-07-17 21:08:03 -0400
committerAndrew Dunstan <andrew@dunslane.net>2015-07-17 21:14:14 -0400
commit473865048517c7808ddcf2299d054d8fe30fc6d5 (patch)
treec8f335feaf7db325664fe45bb4938ac3edf8d649
parente02d44b8a74810341c90add4cd49e428b9d406b9 (diff)
downloadpostgresql-473865048517c7808ddcf2299d054d8fe30fc6d5.tar.gz
postgresql-473865048517c7808ddcf2299d054d8fe30fc6d5.zip
Release note compatibility item
Note that json and jsonb extraction operators no longer consider a negative subscript to be invalid.
-rw-r--r--doc/src/sgml/release-9.5.sgml11
1 files changed, 11 insertions, 0 deletions
diff --git a/doc/src/sgml/release-9.5.sgml b/doc/src/sgml/release-9.5.sgml
index 817b973546a..0b12420aead 100644
--- a/doc/src/sgml/release-9.5.sgml
+++ b/doc/src/sgml/release-9.5.sgml
@@ -162,6 +162,17 @@
</para>
</listitem>
+ <listitem>
+ <para>
+ Allow <type>json</> and <type>jsonb</> extraction operators to
+ accept negative subscripts, which count from the end of JSON
+ arrays. Historically, these operators yielded <literal>NULL</>
+ in the event of a negative subscript, because negative
+ subscripts were considered invalid. (Peter Geoghegan, Andrew
+ Dunstan)
+ </para>
+ </listitem>
+
</itemizedlist>
</sect2>