Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
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


In response to

pgsql-sql by date

Next:From: Bruno BoettcherDate: 2000-11-20 17:47:00
Subject: Re: pgpl-problem, what's wrong with my loop?
Previous:From: Kovacs Zoltan SandorDate: 2000-11-20 17:06:52
Subject: Re: pgpl-problem, what's wrong with my loop?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group