Bob Pawley wrote: > Is it allowed to declare a cursor in this manner?? > > Declare > procgraphic cursor for select p_id.p_id.process_id > from p_id.p_id, processes_count > where p_id.p_id.p_id_id = processes_count.p_id_id; Using DECLARE instead of OPEN? Yes, but that won't somehow make a cursor involving a join updatable. See: http://www.postgresql.org/docs/8.3/interactive/plpgsql-cursors.html DECLARE and OPEN do not have exactly the same meaning, as explained by the above documentation. To use a cursor defined with DECLARE you must use OPEN - see section 38.7.2.3 ("Opening a Bound Cursor") of the documentation. -- Craig Ringer
