On 03/12/2012 16:55, Raymond O'Donnell wrote: > On 30/11/2012 10:25, AZL . wrote: >> >> write a select query and take each row values and do some update or >> insert task postgresql 9.1, can any one give a template of function >> syntax for implementing such a task > > You're probably looking for a with...loop construct in plpgsql: > > http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html#PLPGSQL-RECORDS-ITERATING Sorry, that should have been FOR .... LOOP. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
