Re: Bug in CREATE FUNCTION with character type - Mailing list pgsql-bugs

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? :)

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

            regards, tom lane