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 по дате отправления:

Предыдущее
От: "Diego Cattelan"
Дата:
Сообщение: alter table
Следующее
От: Tom Lane
Дата:
Сообщение: Re: alter table