Re: Check column result size in functions

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, Dec 12, 2023 at 3:13 PM Marcos Pegoraro <marcos@xxxxxxxxxx> 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.