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? :)
I get -1 (indicating unspecified), which is what I'd expect. You
sure about the zero?
regards, tom lane