Thread

Re: Document NULL

Marcos Pegoraro <marcos@f10.com.br> — 2025-11-13T14:39:42Z

Em ter., 11 de nov. de 2025 às 12:34, Álvaro Herrera <alvherre@kurilemu.de>
escreveu:

> I have rebased this; here's v9.  I haven't reviewed it in depth, but
> intend to give it a read and get it pushed sometime in the
> not-too-distant future, so if anybody wants to review it some more, it'd
> be appreciated


Maybe this one
<programlisting>
SELECT
 1 + null AS "Add",
 'text' || null AS "Concatenate";
</programlisting>

Would be good to explain about explicit casting, because only Numeric, Text
and Boolean will work implicitly.

This ones will work
SELECT
 1 + null AS "Add",
 'text' || null AS "Concatenate",
 false or null AS "BoolOR";

But any other datatype will work only if casted properly
select Current_Date + null::integer;
select jsonb_build_object ('x',5) || null::jsonb

regards
Marcos