Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions

From: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
To: Vik Fearing <vik(at)postgresfriends(dot)org>
Cc: jian he <jian(dot)universality(at)gmail(dot)com>, Isaac Morland <isaac(dot)morland(at)gmail(dot)com>, pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
Date: 2025-07-22 15:55:33
Message-ID: CADkLM=dkXxr8S8nCgBaASVUmJQvogP3x3iDFDK=Px375bGqWKg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Jul 22, 2025 at 2:45 AM Vik Fearing <vik(at)postgresfriends(dot)org> 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2025-07-22 16:37:02 Making jsonb_agg() faster
Previous Message Arseniy Mukhin 2025-07-22 15:43:20 Re: amcheck support for BRIN indexes