Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG) - Mailing list pgsql-bugs

From Kevin J Bluck
Subject Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG)
Date
Msg-id 0197a95f0e3c644c82090eafb33efb88@netce.com
Whole thread Raw
In response to Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
>> PostgreSQL functions ignore typmod for parameters...

> ...not something that can be changed without a great
> deal of work --- and application breakage...

Thanks to all for the clarifications. I can make it return what I wanted wi=
th qualified character types by returning a SETOF RECORD types, where the r=
ecord type is a table or aggregate type. The key, it seems, is to avoid usi=
ng output parameters. But if RETURN TABLE doesn't respect typemods, perhaps=
 it shouldn't be legal to specify them in that clause? I don't know. It jus=
t *seems* like a bug if you don=E2=80=99t know why your carefully crafted r=
eturn type is being partially ignored. But now I do, so thanks again.

I do think Pavel G. has a real bug with the char thing, though.

--- Kevin

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5416: int4inc() is wrong
Next
From: Tom Lane
Date:
Subject: Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG)