Re: Plpgsql function syntax error at first coalesce statement

On 25/04/2010 20:50, Jeff Ross wrote:

> Now I'm *really* confused. I thought the table structure I created at
> the beginning of the function was where the results would be returned
> to. I tried a variety of queries including select into and create table
> but they didn't work either.

I think you have to do RETURN NEXT inside the loop:

create function....
declare
return_row record;
...
begin
...
for..
loop
select ... into return_row;
return next return_row;
end loop;
...
return;
end;

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie