Received: from erm1.u-strasbg.fr (erm1.u-strasbg.fr [130.79.74.61]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAKHUAs29940 for ; Mon, 20 Nov 2000 12:30:11 -0500 (EST) (envelope-from bboett@erm1.u-strasbg.fr) Received: (qmail 28748 invoked by uid 501); 20 Nov 2000 17:47:00 -0000 Date: Mon, 20 Nov 2000 18:47:00 +0100 From: Bruno Boettcher To: Kovacs Zoltan Sandor Cc: pgsql-sql@postgresql.org Subject: Re: pgpl-problem, what's wrong with my loop? Message-ID: <20001120184700.I25191@erm1.u-strasbg.fr> References: <20001120172105.E25191@erm1.u-strasbg.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.0.1i In-Reply-To: ; from tip@pc10.radnoti-szeged.sulinet.hu on Mon, Nov 20, 2000 at 06:06:52PM +0100 X-Archive-Number: 200011/160 X-Sequence-Number: 191 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....