Re: function

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

You can probably do it with a CTE also, which would avoid the overhead
of calling the function.

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie