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

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