| From: | Bruno Boettcher <bboett(at)erm1(dot)u-strasbg(dot)fr> |
|---|---|
| To: | Kovacs Zoltan Sandor <tip(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: pgpl-problem, what's wrong with my loop? |
| Date: | 2000-11-20 17:47:00 |
| Message-ID: | 20001120184700.I25191@erm1.u-strasbg.fr |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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.....
> 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....
anyway thanks for the answer...
--
ciao bboett
==============================================================
bboett(at)earthling(dot)net
http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett
===============================================================
the total amount of intelligence on earth is constant.
human population is growing....
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kyle | 2000-11-20 19:10:05 | Bug or feature |
| Previous Message | Kovacs Zoltan Sandor | 2000-11-20 17:40:53 | Re: pgpl-problem, what's wrong with my loop? |