Received: from rama2 (unknown [216.30.143.161]) by postgresql.org (Postfix) with ESMTP id 1766347677F for ; Tue, 5 Mar 2002 10:49:28 -0500 (EST) Received: from aclark by rama2 with local (Exim 3.12 #1 (Debian)) id 16iHBw-00080I-00; Tue, 05 Mar 2002 09:49:28 -0600 Date: Tue, 5 Mar 2002 09:49:28 -0600 From: Ashley Clark To: Hubert Palme Cc: pgsql-interfaces@postgresql.org Subject: Re: PL/pgSQL Syntax Problem Message-ID: <20020305094928.A30697@tyrr.net> References: Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="Q68bSM7Ycu6FN28Q" Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: ; from hubert.palme@web.de on Mon, Mar 04, 2002 at 09:34:25PM +0100 X-URL: http://ghoti.org/~aclark X-GPG-Fingerprint: 1DAB 24C1 B2C1 1A34 AAAD CD2B FC62 B304 4AE0 F2EE X-GPG-Keyid: 0x4AE0F2EE X-Operating-System: Linux rama2 2.2.17 No. 1 Thu Sep 14 18:52:53 CDT 2000 i586 unknown X-Operating-System-Uptime: 9:42am up 54 days, 23:22, 1 user, load average: 0.00, 0.00, 0.00 X-Archive-Number: 200203/30 X-Sequence-Number: 2433 --Q68bSM7Ycu6FN28Q Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable * Hubert Palme in "PL/pgSQL Syntax Problem" dated 2002/03/04 21:34 wrote: > Hi, Hi, > FOR daten IN=20 > SELECT * INTO daten FROM telefon WHERE t_lfd_nr =3D lfd_nr when using a for loop you don't need the into, eg. FOR daten IN SELECT * FROM telefon WHERE t_lfd_nr =3D lfd_nr each row will be placed in daten. --=20 alkyl arches=20 --Q68bSM7Ycu6FN28Q Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Finger aclark@ghoti.org for public key iD8DBQE8hOkI/GKzBErg8u4RAvKbAKCDSt9ybRpiY/8xG0AdEkbIwrexIACeO2wv JZEm8YKKbMI9xmSVeK6SEAE= =VChO -----END PGP SIGNATURE----- --Q68bSM7Ycu6FN28Q--