Re: Proposal: is_castable - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: Proposal: is_castable
Date
Msg-id CAFj8pRBHig4HD4dVhH1PffixX4pcaL2E5jvfqs022cNABKLt6A@mail.gmail.com
Whole thread Raw
In response to Re: Proposal: is_castable  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-hackers
Hi


So it's a two step process for me currently because of this, I would love if there was a better way to handle 
this type of work though, because my plpgsql functions using exception blocks are not exactly great 
for performance.

Probably we can for some important buildin types write method "is_valid", and this method can be called directly. For custom types or for types without this method, the solution based on exceptions can be used.

This should not be too much code, and can be fast for often used types.

pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: proposal \gcsv
Next
From: Petr Jelinek
Date:
Subject: Re: backup manifests and contemporaneous buildfarm failures