PLPGSQL Returning Records - Mailing list pgsql-general

From Alex
Subject PLPGSQL Returning Records
Date
Msg-id 3FB9C6CD.8030908@meerkatsoft.com
Whole thread Raw
Responses Re: PLPGSQL Returning Records  (Stephan Szabo <sszabo@megazone.bigpanda.com>)
List pgsql-general
Hi,
I am trying to return a recod from from my function but for some reason
it does not work.

Here is may problem. I use a for loop to generate the first batch of
records. Once the loop is completed I want to add another record. But at
that point fails.

....

FOR  rec IN SELECT ....
LOOP

  RETURN NEXT r;
END LOOP;

do some assignments
RETURN r;

....

It seems that the function does not return anything after the loop. Can
anyone help me on that ?

Thanks
Alex





pgsql-general by date:

Previous
From: Gianni Mariani
Date:
Subject: building 7.4 with plperl
Next
From: Mark Kirkwood
Date:
Subject: Re: snort, acid and postgres