Home • Explore • Blog • CI
☰



postgresql
20th chunk of `doc/src/sgml/release-18.sgml`
cda3e29b7c74950b26b15a84a1004e499255acf5d4d7b7930000000100000fa3
 url="&commit_baseurl;a5579a90a">&sect;</ulink>
</para>

<para>
Previously such casts generated an error.
</para>
</listitem>

<!--
Author: Andrew Dunstan <andrew@dunslane.net>
2025-03-05 [4603903d2] Allow json{b}_strip_nulls to remove null array elements
-->

<listitem>
<para>
Add optional parameter to json{b}_strip_nulls to allow removal of null array elements (Florents Tselai)
<ulink url="&commit_baseurl;4603903d2">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-04-01 [6c12ae09f] Introduce a SQL-callable function array_sort(anyarray).
-->

<listitem>
<para>
Add function array_sort() which sorts an array's first dimension (Junwang Zhao, Jian He)
<ulink url="&commit_baseurl;6c12ae09f">&sect;</ulink>
</para>
</listitem>

<!--
Author: Michael Paquier <michael@paquier.xyz>
2024-11-01 [49d6c7d8d] Add SQL function array_reverse()
-->

<listitem>
<para>
Add function array_reverse() which reverses an array's first dimension (Aleksander Alekseev)
<ulink url="&commit_baseurl;49d6c7d8d">&sect;</ulink>
</para>
</listitem>

<!--
Author: Nathan Bossart <nathan@postgresql.org>
2025-03-13 [0697b2390] Add reverse(bytea).
-->

<listitem>
<para>
Add function reverse() to reverse bytea bytes (Aleksander Alekseev)
<ulink url="&commit_baseurl;0697b2390">&sect;</ulink>
</para>
</listitem>

<!--
Author: Dean Rasheed <dean.a.rasheed@gmail.com>
2025-03-07 [6da469bad] Allow casting between bytea and integer types.
-->

<listitem>
<para>
Allow casting between integer types and bytea (Aleksander Alekseev)
<ulink url="&commit_baseurl;6da469bad">&sect;</ulink>
</para>

<para>
The integer values are stored as bytea two's complement values.
</para>
</listitem>

<!--
Author: Peter Eisentraut <peter@eisentraut.org>
2025-04-03 [82a46cca9] Update Unicode data to Unicode 16.0.0
-->

<listitem>
<para>
Update Unicode data to Unicode 16.0.0 (Peter Eisentraut)
<ulink url="&commit_baseurl;82a46cca9">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2025-02-18 [b464e51ab] Update to latest Snowball sources.
-->

<listitem>
<para>
Add full text search stemming for Estonian (Tom Lane)
<ulink url="&commit_baseurl;b464e51ab">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2024-09-24 [cd838e200] Neaten up our choices of SQLSTATEs for XML-related error
-->

<listitem>
<para>
Improve the XML error codes to more closely match the SQL standard (Tom Lane)
<ulink url="&commit_baseurl;cd838e200">&sect;</ulink>
</para>

<para>
These errors are reported via SQLSTATE.
</para>
</listitem>

    </itemizedlist>

   </sect3>

   <sect3 id="release-18-functions">
    <title>Functions</title>

    <itemizedlist>

<!--
Author: Jeff Davis <jdavis@postgresql.org>
2025-01-24 [bfc599206] Add SQL function CASEFOLD().
-->

<listitem>
<para>
Add function CASEFOLD() to allow for more sophisticated case-insensitive matching (Jeff Davis)
<ulink url="&commit_baseurl;bfc599206">&sect;</ulink>
</para>

<para>
Allows more accurate comparison, i.e., a character can have multiple upper or lower case equivalents, or upper or lower case conversion changes the number of characters.
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2024-07-11 [a0f1fce80] Add min and max aggregates for composite types (records)
Author: Tom Lane <tgl@sss.pgh.pa.us>
2024-10-08 [2d24fd942] Add min and max aggregates for bytea type.
-->

<listitem>
<para>
Allow MIN()/MAX() aggregates on arrays and composite types (Aleksander Alekseev, Marat Buharov)
<ulink url="&commit_baseurl;a0f1fce80">&sect;</ulink>
<ulink url="&commit_baseurl;2d24fd942">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2024-08-16 [6be39d77a] Fix extraction of week and quarter fields from intervals
-->

<listitem>
<para>
Add a WEEK option to EXTRACT() (Tom Lane)
<ulink url="&commit_baseurl;6be39d77a">&sect;</ulink>
</para>
</listitem>

<!--
Author: Tom Lane <tgl@sss.pgh.pa.us>
2024-08-16 [6be39d77a] Fix extraction of week and quarter
Title: PostgreSQL 18: Data Types and Functions Updates
Summary
This section outlines several data type and function updates in PostgreSQL 18. It includes allowing jsonb "null" values to be cast to scalar types as NULL, adding an optional parameter to json{b}_strip_nulls to allow removal of null array elements, introducing functions array_sort() and array_reverse(), adding function reverse() to reverse bytea bytes, allowing casting between integer types and bytea, updating Unicode data to Unicode 16.0.0, adding full text search stemming for Estonian, improving the XML error codes to more closely match the SQL standard, adding function CASEFOLD() for more sophisticated case-insensitive matching, allowing MIN()/MAX() aggregates on arrays and composite types, and adding a WEEK option to EXTRACT().