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 [EMAIL PROTECTED]
