Andrew Dunstan <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> What I think we'd need to have a complete solution is >> >> convert(text, name) returns bytea >> -- convert from DB encoding to arbitrary encoding >> >> convert(bytea, name, name) returns bytea >> -- convert between any two encodings >> >> convert(bytea, name) returns text >> -- convert from arbitrary encoding to DB encoding >> >> The second and third would need to do a verify step before >> converting, of course.
> Is there any reason these functions shouldn't be marked immutable? No, not as long as DB encoding is frozen... > I'm wondering if we should give them disambiguating names, rather than > call them all convert. No. We have a function overloading system, we should use it. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster