Bug #915: problem with returning setof with double precision values
От | pgsql-bugs@postgresql.org |
---|---|
Тема | Bug #915: problem with returning setof with double precision values |
Дата | |
Msg-id | 20030321115747.F3869474E4F@postgresql.org обсуждение исходный текст |
Ответы |
Re: Bug #915: problem with returning setof with double precision values
Re: Bug #915: problem with returning setof with double precision |
Список | pgsql-bugs |
Daniel Brozek (d.brozek@adv.pl) reports a bug with a severity of 2 The lower the number the more severe it is. Short Description problem with returning setof with double precision values Long Description I have got the table and the function (look at example code). After executing this function I have got NULL values in theplace of double precision columns. But in database those values are set. Simple SELECT (select * from service) from thistable works propertly - double precision columns have their proper values. I am working with 7.3.2 version of Postgresql. Sample Code CREATE FUNCTION get_krd_info (INTEGER) RETURNS SETOF service AS ' DECLARE l_service_id ALIAS FOR $1; l_service service%ROWTYPE; BEGIN SELECT INTO l_service service* FROM service WHERE service.service_id = l_service_id; RETURN NEXT l_service; RETURN; END; ' LANGUAGE 'plpgsql'; No file was uploaded with this report
В списке pgsql-bugs по дате отправления: