Pavel Golub <pavel(at)microolap(dot)com> writes:
> CREATE OR REPLACE FUNCTION test_char_function()
> RETURNS TABLE(id int, salesourcecode character) AS
> VALUES (1, 'one'), (2, 'two'), (3, 'three');
> 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
In response to
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2010-04-14 22:12:34|
|Subject: Re: Bug in CREATE FUNCTION with character type (CONFIRMED BUG) |
|Previous:||From: Kevin Grittner||Date: 2010-04-14 21:45:24|
|Subject: Re: [BUGS] BUG #5412: test case produced, possible race condition.|