Re: PL/pgSQL Syntax Problem

On 2002-03-04 21:34 Hubert Palme <hubert(dot)palme(at)web(dot)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