at for over select rows

Hi,

I couldn't find the logical error in my function, so I was wondering if there
could be a bug. The function is created, but when I try to use it I get the
following error message:

NOTICE:  Error occurred while executing PL/pgSQL function apaga_constraint
NOTICE:  line 20 at for over select rows
ERROR:  parser: parse error at or near "$1"

The function code follows:

CREATE OR REPLACE FUNCTION apaga_constraint (varchar)
RETURNS INTEGER AS '
DECLARE
  nome       ALIAS FOR $1;
  registro   RECORD;
  qtd        INTEGER;
  constr_oid INTEGER;
BEGIN

  qtd := 0;

    SELECT oid
    INTO constr_oid
    FROM pg_class
    WHERE relname::TEXT = nome;

    -- Caso nao seja chave primaria
    IF NOT FOUND THEN

      RAISE NOTICE ''Nao eh pk: %'', nome;

      FOR registro IN
        SELECT t.tgrelid, COUNT(t.tgname) AS qtd
        FROM pg_trigger t
        WHERE t.tgconstrname::TEXT = nome
        GROUP BY t.tgrelid
      LOOP
        RAISE NOTICE ''Class: % Triggers: %'', registro.tgrelid, registro.qtd;
      END LOOP;

    -- Caso seja chave primaria
    ELSE
      RAISE NOTICE ''Oid: %'', constr_oid;
    END IF;

  RETURN qtd;

END;
' LANGUAGE 'plpgsql';

SELECT apaga_constraint('fk_teste2_teste');

My apologies for this poor english,
Alvaro

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/