On Tue, 18 Nov 2003, Alex wrote:
> 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;
I think you want RETURN NEXT r; (or rec) to add the record to the
set of output rows.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
