Postgres Pro
Downloads
Home   >   mailing lists

Re: Check column result size in functions - Mailing list pgsql-general

From David G. Johnston
Subject Re: Check column result size in functions
Date
Msg-id CAKFQuwY7jUtkV6YfJfTAVqQ2oys4cX0byzWC2JWyUTHWDafcqA@mail.gmail.com
Whole thread Raw
In response to Check column result size in functions  (Marcos Pegoraro <marcos@f10.com.br>)
List pgsql-general
Tree view
On Tue, Dec 12, 2023 at 3:13 PM Marcos Pegoraro <marcos@f10.com.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.

pgsql-general by date:

Previous
From: Marcos Pegoraro
Date:
Subject: Check column result size in functions
Next
From: Laurenz Albe
Date:
Subject: Re: how can I fix my accent issues?