Re: Function Returning SETOF Problem

On Wed, 17 Dec 2003, Ron St-Pierre wrote:

> Stephan Szabo wrote:
>
> >On Wed, 17 Dec 2003, Ron St-Pierre wrote:
> >
> >
> >
> >>On a daily basis I place a lot of data into the empty table dailyList,
> >>and from that data update certain fields in currentList. I thought that
> >>using a function would be a good way to do this(?). However I get the
> >>following error when I run updateCurrentData():
> >> ERROR: set-valued function called in context that cannot accept a set
> >> CONTEXT: PL/pgSQL function "updatecurrentcata" line 6 at return next
> >>I've googled and tried variations on the function, but without success.
> >>Can anyone help?
> >>
> >>
> >
> >This probably means that you're calling it like:
> > select updateCurrentData();
> >and you'll need to instead call it with the function in the FROM clause,
> >something like:
> > select * from updateCurrentData();
> >
> >---------------------------(end of broadcast)---------------------------
> >TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
> >
> >
> >
> >
> aha, that's part of it. I now get this error:
> ERROR: wrong record type supplied in RETURN NEXT
> Any ideas on this one?

That sounds like a mismatch between the record in rec and your declared
output type, but I couldn't say for sure without a complete example
including the table declarations really.