On Tue, Dec 12, 2023 at 3:13 PM Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> wrote:
> My functions should return varchar(5) or should return an exception, but
> sometimes they return CHARACTER VARYING. Why ?
>
> thanks for any explanation
>
The observed behavior is documented.
https://www.postgresql.org/docs/current/sql-createfunction.html (see notes)
David J.