Re: Bug in CREATE FUNCTION with character type

Hello, Tom.

You wrote:

TL> Pavel Golub <pavel(at)microolap(dot)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(at)gf(dot)microolap(dot)com