[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: Re: Check column result size in functions
From: "David G. Johnston" <david.g.johnston () gmail ! com>
Date: 2023-12-12 22:29:27
Message-ID: CAKFQuwY7jUtkV6YfJfTAVqQ2oys4cX0byzWC2JWyUTHWDafcqA () mail ! gmail ! com
[Download RAW message or body]
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.
[Attachment #3 (text/html)]
<div dir="ltr"><div dir="ltr"><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><span \
style="font-family:Arial,Helvetica,sans-serif">On Tue, Dec 12, 2023 at 3:13 PM \
Marcos Pegoraro <<a href="mailto:marcos@f10.com.br">marcos@f10.com.br</a>> \
wrote:</span><br></div></div><div class="gmail_quote"><blockquote class="gmail_quote" \
style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div \
style="font-family:verdana,sans-serif;color:rgb(102,102,102)">My functions should \
return varchar(5) or should return an exception, but sometimes they return CHARACTER \
VARYING. Why ?</div><div \
style="font-family:verdana,sans-serif;color:rgb(102,102,102)"><br></div><div \
style="font-family:verdana,sans-serif;color:rgb(102,102,102)">thanks for any \
explanation</div></div></blockquote><div><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">The observed behavior is \
documented.</div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><a \
href="https://www.postgresql.org/docs/current/sql-createfunction.html">https://www.postgresql.org/docs/current/sql-createfunction.html</a> \
(see notes)<br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif"><br></div><div class="gmail_default" \
style="font-family:arial,helvetica,sans-serif">David J.</div></div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic