Received: from jupiter.hub.org (jupiter.hub.org [64.49.215.5]) by postgresql.org (Postfix) with ESMTP id A536447620A; Mon, 4 Mar 2002 16:03:50 -0500 (EST) Received: (from news@localhost) by jupiter.hub.org (8.11.6/8.11.6) id g24KYQj06923; Mon, 4 Mar 2002 14:34:26 -0600 (CST) (envelope-from news) From: Hubert Palme X-Newsgroups: comp.databases.postgresql.general, comp.databases.postgresql.interfaces, comp.databases.postgresql.sql Subject: PL/pgSQL Syntax Problem Followup-To: comp.databases.postgresql.general Date: Mon, 4 Mar 2002 21:34:25 +0100 Organization: None Lines: 43 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7Bit X-Complaints-To: news@hub.org User-Agent: KNode/0.4 To: pgsql-general@postgresql.org.pgsql-interfaces@postgresql.org.pgsql-sql@postgresql.org X-Archive-Number: 200203/328 X-Sequence-Number: 21706 Hi, this function: CREATE FUNCTION t_nummern(integer) -- Parameter: lfd_nr RETURNS text AS ' DECLARE lfd_nr ALIAS FOR $1; erg text; daten record; BEGIN erg := ''''; FOR daten IN SELECT * INTO daten FROM telefon WHERE t_lfd_nr = lfd_nr LOOP IF erg <> '''' THEN erg := erg || '', ''; END IF; IF daten.t_einrichtg <> '''' THEN erg := erg || daten.t_einrichtg || '': ''; END IF; erg := erg || ''('' || daten.vorwahl || '') '' || daten.telefon_nr; END LOOP; RETURN erg; END;' LANGUAGE 'plpgsql'; causes the following error: mitglieder=> select t_nummern(330); ERROR: query "SELECT * INTO daten FROM telefon WHERE t_lfd_nr = $1 " isn't a SELECT mitglieder=> Why isn't this a SELECT?? Thanks in advance, -- Hubert Palme Am Walde 1 42119 Wuppertal