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
