[postgis-users] Error

[Kevin Neufeld]

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
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>