Re: implement CAST(expr AS type FORMAT 'template') - Mailing list pgsql-hackers

On 06.07.26 19:14, Haibo Yan wrote:
> The cases where I think a generic mechanism could be useful are
> broader than that.  For example:
> 
>      text <-> date/time        using datetime templates
>      text <-> numeric          using number templates
>      text <-> bytea            using hex/base64/escape
>      text/bytea <-> extension types
>                            using external representations such as
>                            WKT/WKB/GeoJSON for geometry types
One problem I see is that this would dictate that there is only one 
possible format language for each of these conversions.