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:08:03 -0400
commit0beef5af3a4821155251d8d445b9ba1296381645 (patch)
treef7caf1215ee2af05c1b421fce83d4a2b49a94bde
parent89ddd29bbd70c31652c6e7a179473753b89a3cac (diff)
downloadpostgresql-0beef5af3a4821155251d8d445b9ba1296381645.tar.gz
postgresql-0beef5af3a4821155251d8d445b9ba1296381645.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 a1010b29b87..dff1ba9ae0b 100644
--- a/doc/src/sgml/release-9.5.sgml
+++ b/doc/src/sgml/release-9.5.sgml
@@ -141,6 +141,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>