8000 Release note compatibility item · postgres/postgres@4738650 · GitHub
[go: up one dir, main page]
Skip to content

Commit 4738650

Browse files
adunstanadunstan
committed
Release note compatibility item
Note that json and jsonb extraction operators no longer consider a negative subscript to be invalid.
1 parent e02d44b commit 4738650

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
@@ -162,6 +162,17 @@
162162
</para>
163163
</listitem>
164164

165+
<listitem>
166+
<para>
167+
Allow <type>json</> and <type>jsonb</> extraction operators to
168+
accept negative subscripts, which count from the end of JSON
169+
arrays. Historically, these operators yielded <literal>NULL</>
170+
in the event of a negative subscript, because negative
171+
subscripts were considered invalid. (Peter Geoghegan, Andrew
172+
Dunstan)
173+
</para>
174+
</listitem>
175+
165176
</itemizedlist>
166177

167178
</sect2>

0 commit comments

Comments
 (0)
0