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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
