Re: pgpl-problem, what's wrong with my loop?

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@earthling.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....