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@iol.ie