Re: problem with triggers

miguel angel rojas aquino <mrojas_aquino@mail.flashmail.com> writes:
>  DECLARE
>   registro RECORD;
>  BEGIN

>  IF NEW.inscripcion = 0 THEN
>   SELECT * INTO registro
>   FROM precios
>   WHERE NEW.curso = registro.curso AND
>         NEW.sistema = registro.sistema AND
>         NEW.turno = registro.turno AND
>         NEW.semestre = registro.semestre;

> but every time i insert a new record, it says something like:
> "ERROR record registro not assigned yet"

I'm betting that you meant to refer to precios, not registro,
in the WHERE clause.

            regards, tom lane