Postgres Pro
Downloads
Home   >   mailing lists

Thread: function

function

From
"AZL ."
Date:
 write a select query and take each row values and do some update or insert task postgresql 9.1, can any one give a
templateof function syntax for implementing such a task

Re: function

From
Raymond O'Donnell
Date:
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

Re: function

From
Raymond O'Donnell
Date:
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