| From: | Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> |
|---|---|
| To: | Álvaro Herrera <alvherre(at)kurilemu(dot)de> |
| Cc: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, jian he <jian(dot)universality(at)gmail(dot)com>, Jeff Davis <pgsql(at)j-davis(dot)com>, Yugo NAGATA <nagata(at)sraoss(dot)co(dot)jp>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Peter Eisentraut <peter(at)eisentraut(dot)org>, David Rowley <dgrowleyml(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Document NULL |
| Date: | 2025-11-13 14:39:42 |
| Message-ID: | CAB-JLwZ=c_voY_Jsrqz1uvfRnSRD-o_iYuDahbpw28JNZVH6Uw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Em ter., 11 de nov. de 2025 às 12:34, Álvaro Herrera <alvherre(at)kurilemu(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2025-11-13 15:26:32 | Re: pg_getaddrinfo_all() with hintp=NULL |
| Previous Message | Matheus Alcantara | 2025-11-13 14:36:09 | Re: Include extension path on pg_available_extensions |