From: | Pavel Golub <pavel(at)microolap(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Bug in CREATE FUNCTION with character type |
Date: | 2010-04-12 12:51:28 |
Message-ID: | 864494396.20100412155128@gf.microolap.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Hello, Pgsql-bugs.
PostgreSQL version: 8.4.x
Operating system: All
If RETURNS TABLE clause of CREATE FUNCTION contain column of character type (withou
length specifier) it should be treated as character(1) according to
manual, but it look like text.
(http://www.postgresql.org/docs/8.4/static/datatype-character.html)
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? :)
(http://www.postgresql.org/docs/8.4/static/libpq-exec.html#LIBPQ-EXEC-SELECT-INFO)
--
With best wishes,
Pavel mailto:pavel(at)gf(dot)microolap(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Robert Haas | 2010-04-12 13:23:56 | Re: initdb stores default client_encoding from environment-variable |
Previous Message | Martin von Gagern | 2010-04-12 12:15:45 | build error: strlcat/strlcpy used from heimdal libroken.so |