MIME-Version: 1.0
References: <CADkLM=fv1JfY4Ufa-jcwwNbjQixNViskQ8jZu3Tz_p656i_4hQ@mail.gmail.com>
In-Reply-To: <CADkLM=fv1JfY4Ufa-jcwwNbjQixNViskQ8jZu3Tz_p656i_4hQ@mail.gmail.com>
From: Isaac Morland <isaac.morland@gmail.com>
Date: Tue, 28 Mar 2023 15:25:05 -0400
Message-ID: <CAMsGm5dpfm2PHL8XZvC-JSd+UPkgx3rpReUA=G=4+rUCH+Ntcw@mail.gmail.com>
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
To: Corey Huinker <corey.huinker@gmail.com>
Cc: pgsql-hackers@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000ca95b605f7fad1b4"
Archived-At: <https://www.postgresql.org/message-id/CAMsGm5dpfm2PHL8XZvC-JSd%2BUPkgx3rpReUA%3DG%3D4%2BrUCH%2BNtcw%40mail.gmail.com>
Precedence: bulk

--000000000000ca95b605f7fad1b4
Content-Type: text/plain; charset="UTF-8"

On Mon, 19 Dec 2022 at 17:57, Corey Huinker <corey.huinker@gmail.com> wrote:

>
> Attached is my work in progress to implement the changes to the CAST()
> function as proposed by Vik Fearing.
>
> CAST(expr AS typename NULL ON ERROR)
>     will use error-safe functions to do the cast of expr, and will return
> NULL if the cast fails.
>
> CAST(expr AS typename DEFAULT expr2 ON ERROR)
>     will use error-safe functions to do the cast of expr, and will return
> expr2 if the cast fails.
>

Is there any difference between NULL and DEFAULT NULL?

--000000000000ca95b605f7fad1b4
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, 19 Dec 2022 at 17:57, Corey Huink=
er &lt;<a href=3D"mailto:corey.huinker@gmail.com">corey.huinker@gmail.com</=
a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote class=3D"gmai=
l_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left-width:1px;border-lef=
t-style:solid;border-left-color:rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><br><div>Attached is my work in progress to implement the changes =
to the CAST() function as proposed by Vik Fearing.</div><div><br></div><div=
><div>CAST(expr AS typename NULL ON ERROR)</div><div>=C2=A0 =C2=A0 will use=
 error-safe functions to do the cast of expr, and will return NULL if the c=
ast fails.</div><div><br></div><div><div>CAST(expr AS typename DEFAULT expr=
2 ON ERROR)<br>=C2=A0 =C2=A0 will use error-safe functions to do the cast o=
f expr, and will return expr2 if the cast fails.</div></div></div></div></b=
lockquote><div><br></div><div>Is there any difference between NULL and DEFA=
ULT NULL?=C2=A0</div></div></div>

--000000000000ca95b605f7fad1b4--