From 0beef5af3a4821155251d8d445b9ba1296381645 Mon Sep 17 00:00:00 2001 From: Andrew Dunstan Date: Fri, 17 Jul 2015 21:08:03 -0400 Subject: [PATCH] Release note compatibility item Note that json and jsonb extraction operators no longer consider a negative subscript to be invalid. --- doc/src/sgml/release-9.5.sgml | 11 +++++++++++ 1 file changed, 11 insertions(+) diff --git a/doc/src/sgml/release-9.5.sgml b/doc/src/sgml/release-9.5.sgml index a1010b29b8..dff1ba9ae0 100644 --- a/doc/src/sgml/release-9.5.sgml +++ b/doc/src/sgml/release-9.5.sgml @@ -141,6 +141,17 @@ + + + Allow json and jsonb extraction operators to + accept negative subscripts, which count from the end of JSON + arrays. Historically, these operators yielded NULL + in the event of a negative subscript, because negative + subscripts were considered invalid. (Peter Geoghegan, Andrew + Dunstan) + + + -- 2.40.0