From: | Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
---|---|
To: | Bruno Boettcher <bboett(at)erm1(dot)u-strasbg(dot)fr> |
Cc: | pgsql-sql(at)postgresql(dot)org, JanWieck(at)t-online(dot)de |
Subject: | Re: pgpl-problem, what's wrong with my loop? |
Date: | 2000-11-20 17:40:53 |
Message-ID: | Pine.LNX.4.05.10011201831030.6284-100000@pc10.radnoti-szeged.sulinet.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
On Mon, 20 Nov 2000, Bruno Boettcher wrote:
> On Mon, Nov 20, 2000 at 06:06:52PM +0100, Kovacs Zoltan Sandor wrote:
> > > FOR arow IN SELECT currency,amount FROM journal WHERE col=sumup LOOP
> > My opinion is the problem that you cannot give a column name as a
> > parameter. But I'm not sure. This never worked for me. The thing here
> :( can somebody confirm this? in this case i have to check only 2
> cols....
> put if i had more to check, this would be a serious limitation.....
I sent this question to the list about 4 months ago without receiving any
answers. Jan, could you please help?
> > You should write different codes for the different col parameters in my
> > opinion. Or you might write a C function which can send arbitrary SQL
> > queries to the backend.
> :D wanted to stay as SQL'is as possible....
Me too. PLPGSQL is a good piece of ware. :-)
Zoltan
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Boettcher | 2000-11-20 17:47:00 | Re: pgpl-problem, what's wrong with my loop? |
Previous Message | Kovacs Zoltan Sandor | 2000-11-20 17:06:52 | Re: pgpl-problem, what's wrong with my loop? |