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 IN
The function behaves as expected when in plain SQL, only plpgsql
function has the above mentioned problem.
regards
mk
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
2008/8/4 Marcin Krawczyk [EMAIL PROTECTED]
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 :=
Dzieki za odpowiedz. Ciekawe ze funkcja SQL dziala bez problemu - ale
tu juz trzeba wskazac parametry OUT.
Thanks for your answer. It's curious that SQL function works as
expected - but requires OUT params.
pozdrowienia/regards
mk
2008/8/4 Pawel Socha [EMAIL PROTECTED]:
2008/8/4 Marcin
Pawel Socha [EMAIL PROTECTED] writes:
2008/8/4 Marcin Krawczyk [EMAIL PROTECTED]
Hi everybody. Can anyone enlighten me what's wrong with this function :
[ you didn't do RETURN next w; ]
IIRC the other way is to assign to the output parameters by name, then
do RETURN NEXT with no argument.