[postgis-users] Error
Kevin Neufeld
kneufeld at refractions.net
Fri Dec 11 22:41:11 PST 2009
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
>
More information about the postgis-users
mailing list