Hello, Tom. You wrote:
TL> Pavel Golub <pa...@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:pa...@gf.microolap.com -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
