How did you define deviceid? It must be of type "record".
-- Kevin
Bob Pawley wrote:
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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
