Forum OpenACS Development: Response to plpgsql help porting static-pages please

Collapse
Posted by Vinod Kurup on
Hi Dave,

I think the 'FOR var in SQL-STATEMENT' can only be used if 'var' is a record or a %ROWTYPE.

declare ... v_stale_file_row static_pages%ROWTYPE; or v_stale_file_row record; ... begin ... for v_stale_file_row in select ... loop perform static_page__delete(v.stale_file_row.static_page_id); end loop; ...