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

From: Isaac Morland <isaac(dot)morland(at)gmail(dot)com>
To: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Cc: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions
Date: 2023-03-28 19:25:05
Message-ID: CAMsGm5dpfm2PHL8XZvC-JSd+UPkgx3rpReUA=G=4+rUCH+Ntcw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Mon, 19 Dec 2022 at 17:57, Corey Huinker <corey(dot)huinker(at)gmail(dot)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?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message samay sharma 2023-03-28 19:27:26 Re: Documentation for building with meson
Previous Message Pavel Stehule 2023-03-28 19:03:47 Re: Schema variables - new implementation for Postgres 15