Content-Length: 271661 | pFad | http://github.com/postgrespro/postgres/commit/473865048517c7808ddcf2299d054d8fe30fc6d5

6B Release note compatibility item · postgrespro/postgres@4738650 · GitHub
Skip to content

Commit 4738650

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 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)








ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://github.com/postgrespro/postgres/commit/473865048517c7808ddcf2299d054d8fe30fc6d5

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy