Re: Bug in CREATE FUNCTION with character type

Hello, Tom.

You wrote:

TL> Pavel Golub <pavel@microolap.com> writes:
>> Example:

>> CREATE OR REPLACE FUNCTION test_char_function()
>>   RETURNS TABLE(id int, salesourcecode character) AS
>> $BODY$
>> VALUES (1, 'one'), (2, 'two'), (3, 'three');
>> $BODY$
>>   LANGUAGE 'sql'

>> pqfmod function from libpq library for salesourcecode column returns
>> 0, which is wrong. Who can ever imagine bpchar of length 0? :)

TL> I get -1 (indicating unspecified), which is what I'd expect.  You
TL> sure about the zero?

TL>                         regards, tom lane

My fault. Yes, of course, it's -1

--
With best wishes,
 Pavel                          mailto:pavel@gf.microolap.com