MIME-Version: 1.0
References: 
 <CADkLM=fv1JfY4Ufa-jcwwNbjQixNViskQ8jZu3Tz_p656i_4hQ@mail.gmail.com>
 <CAMsGm5dpfm2PHL8XZvC-JSd+UPkgx3rpReUA=G=4+rUCH+Ntcw@mail.gmail.com>
 <CADkLM=eD_S8mGhPfu5+hXXvXgR0-cxGpGd9dgPzD+nCuO7HFaQ@mail.gmail.com>
 <CACJufxHCMzrHOW=wRe8L30rMhB3sjwAv1LE928Fa7sxMu1Tx-g@mail.gmail.com>
 <04afcd1f-ed7d-4c0a-add1-50e3719ccbf9@postgresfriends.org>
In-Reply-To: <04afcd1f-ed7d-4c0a-add1-50e3719ccbf9@postgresfriends.org>
From: Corey Huinker <corey.huinker@gmail.com>
Date: Tue, 22 Jul 2025 11:55:33 -0400
Message-ID: 
 <CADkLM=dkXxr8S8nCgBaASVUmJQvogP3x3iDFDK=Px375bGqWKg@mail.gmail.com>
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User
 Functions
To: Vik Fearing <vik@postgresfriends.org>
Cc: jian he <jian.universality@gmail.com>,
 Isaac Morland <isaac.morland@gmail.com>,
	pgsql-hackers@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000108568063a86a0d3"
Archived-At: 
 <https://www.postgresql.org/message-id/CADkLM%3DdkXxr8S8nCgBaASVUmJQvogP3x3iDFDK%3DPx375bGqWKg%40mail.gmail.com>
Precedence: bulk

--000000000000108568063a86a0d3
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Tue, Jul 22, 2025 at 2:45=E2=80=AFAM Vik Fearing <vik@postgresfriends.or=
g> wrote:

>
> On 22/07/2025 03:59, jian he wrote:
> > Based on my reading of [4], it seems CAST(EXPRESSION AS TYPE DEFAULT
> > def_expr ON ERROR)
> > is not included in SQL:2023.
> >
> > [4]
> https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is=
-whats-new
>
>
> It was accepted into the standard after 2023 was released.  I am the
> author of this change in the standard, so feel free to ask me anything
> you're unsure about.
>
>
That's excellent news. I was already planning on retrying this for v19, but
I'll try sooner now.

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote g=
mail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">On Tue, Jul 22,=
 2025 at 2:45=E2=80=AFAM Vik Fearing &lt;<a href=3D"mailto:vik@postgresfrie=
nds.org">vik@postgresfriends.org</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rg=
b(204,204,204);padding-left:1ex"><br>
On 22/07/2025 03:59, jian he wrote:<br>
&gt; Based on my reading of [4], it seems CAST(EXPRESSION AS TYPE DEFAULT<b=
r>
&gt; def_expr ON ERROR)<br>
&gt; is not included in SQL:2023.<br>
&gt;<br>
&gt; [4]<a href=3D"https://peter.eisentraut.org/blog/2023/04/04/sql-2023-is=
-finished-here-is-whats-new" rel=3D"noreferrer" target=3D"_blank">https://p=
eter.eisentraut.org/blog/2023/04/04/sql-2023-is-finished-here-is-whats-new<=
/a><br>
<br>
<br>
It was accepted into the standard after 2023 was released.=C2=A0 I am the <=
br>
author of this change in the standard, so feel free to ask me anything <br>
you&#39;re unsure about.<br><br></blockquote><div><br></div><div>That&#39;s=
 excellent news. I was already planning on retrying this for v19, but I&#39=
;ll try sooner now.</div><div>=C2=A0</div></div></div>

--000000000000108568063a86a0d3--