On 2002-03-04 21:34 Hubert Palme <hubert.palme@web.de> wrote :
>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
Remove this ^^^^^^^^^^
so that the "FOR ... SELECT" is
FOR daten IN
SELECT * 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';
regards
--
Rolf