On Feb 18, 2024, at 15:55, Erik Wienhold <ewie@ewie.name> wrote:
>> The overhead of parse_type_and_format can be related to higher planning
>> time. PL/pgSQL can assign composite without usage FROM clause.
>
> Thanks, didn't know that this makes a difference. In that case both
> variants are on par.
Presumably this is a side-effect of the use of a RECORD here, which requires a FROM clause in pure SQL, yes?
The only way I can think of to avoid that is to:
1. Add a to_regtypmod() for those who just want the typemod.
2. Add a format_type_string() function that returns a string, the equivalent of this function but in C:
CREATE FUNCTION format_type_string(text) RETURNS TEXT AS $$
SELECT format_type(to_regtype($1), to_regtypmod($1))
$$;
We could also keep the record-returning function for users who want both the regtype and the regytypemod at once, but
withthe other two I consider it less essential.
Thoughts?
Best,
David
