return setof record - strange behavior
От | Marcin Krawczyk |
---|---|
Тема | return setof record - strange behavior |
Дата | |
Msg-id | 95f6bf9b0808040253o371f7929l7845e7f7826cacdf@mail.gmail.com обсуждение исходный текст |
Ответы |
return setof record - strange behavior
Re: return setof record - strange behavior |
Список | pgsql-sql |
Hi everybody. Can anyone enlighten me what's wrong with this function : CREATE OR REPLACE FUNCTION month_year(mon integer, intv integer, OUT ro integer, OUT mi integer) RETURNS SETOF record AS $BODY$ DECLARE w record; cy integer := EXTRACT (YEAR FROM current_date); BEGIN FOR w INSELECT (CASE WHEN m > 12 THEN cy + 1 ELSE cy END)::integer, (CASE WHEN m > 12 THEN m - 12 ELSE m END)::integerFROM generate_series(mon + 1, mon + intv) AS m LOOPRETURN next; END LOOP; END; $BODY$ LANGUAGE 'plpgsql' VOLATILE; SELECT * FROM month_year(10, 5); Why does it return empty SET ? The amount of rows is correct though .... I'm running 8.1.4 regards mk
В списке pgsql-sql по дате отправления: