Skip to content

Commit 0beef5a

Browse files
committed
Release note compatibility item
Note that json and jsonb extraction operators no longer consider a negative subscript to be invalid.
1 parent 89ddd29 commit 0beef5a

File tree

1 file changed

+11
-0
lines changed

1 file changed

+11
-0
lines changed

doc/src/sgml/release-9.5.sgml

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -141,6 +141,17 @@
141141
</para>
142142
</listitem>
143143

144+
<listitem>
145+
<para>
146+
Allow <type>json</> and <type>jsonb</> extraction operators to
147+
accept negative subscripts, which count from the end of JSON
148+
arrays. Historically, these operators yielded <literal>NULL</>
149+
in the event of a negative subscript, because negative
150+
subscripts were considered invalid. (Peter Geoghegan, Andrew
151+
Dunstan)
152+
</para>
153+
</listitem>
154+
144155
</itemizedlist>
145156

146157
</sect2>

0 commit comments

Comments
 (0)