| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | rod(at)iol(dot)ie |
| Cc: | "AZL (dot)" <toafzal777(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: function |
| Date: | 2012-12-03 17:24:42 |
| Message-ID: | 50BCE05A.1080408@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)iol(dot)ie
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Crawford | 2012-12-03 19:16:58 | Re: Postgres PHP error |
| Previous Message | Raymond O'Donnell | 2012-12-03 16:55:42 | Re: function |