Re: implement CAST(expr AS type FORMAT 'template')

[Peter Eisentraut]

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.