[postgis-users] Error

[Bob Pawley]

I recieved an error which I don't understand.

Would it be possible for someone to translate it?

ERROR:  loop variable of loop over rows must be a record or row variable or list of scalar variables at or near "Loop"

Here is the function that leads into the loop, if of any help.

For deviceid In Select devices_id 
 from p_id.processes, p_id.p_id, processes_count, p_id.devices
 where p_id.processes.ip_op_equipment = 'op'
 and p_id.processes.process_id = p_id.p_id.process_id
 and p_id.processes.pump1 = 'True'
 and p_id.processes.p_id_id = processes_count.p_id_id
-- and p_id.devices.fluid_id = fluidid2
 order by p_id.processes.process_id desc,
 p_id.devices.devices_id asc
 
 Loop

..........

Thanks

Bob
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091211/789c08ba/attachment.html>