From: Najm Hashmi <najm@mondo-live.com>
To: Jie Liang <jliang@ipinc.com>
Cc: pgsql <pgsql-sql@postgresql.org>
Subject: Re: What's wrong with this function
Date: Sat, 10 Feb 2001 15:23:15 -0500
Message-ID: <3A85A333.C4DA82EF@mondo-live.com> (raw)
References: <Pine.BSF.4.10.10102091025110.33254-100000@tidal.ipinc.com>
Jie Liang wrote:
> I just know you can use implict cursor inside the plpgsql
> e.g
> declare
result text;
tcount int4;
>
> rec record;
> begin
> FOR rec IN select_clause LOOP
> statements
> END LOOP;
> end;
>
Thank you Jie for your help. I am bit confused about how it works. I want for
each row , obtained by select statment, get certain values and then do some
calculations and out put that resulst eg
for rec IN select title, dcount from songs where artist='xyz'
tcount:= tcount+rec.dcount;
END LOOP;
return tcount;
would this work ?
Thanks again for your help.
Regards, Najm
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: najm@mondo-live.com, jliang@ipinc.com
Subject: Re: What's wrong with this function
In-Reply-To: <3A85A333.C4DA82EF@mondo-live.com>
References: <Pine.BSF.4.10.10102091025110.33254-100000@tidal.ipinc.com> <3A85A333.C4DA82EF@mondo-live.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox