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
