Re: Question regarding triggers

> Why dont you try to write your trigger in C?

Hi, one cannot write triggered procedures in C. Currently, it can only be
written in plpsgql.

> > CREATE FUNCTION "public"."check_shipment" () RETURNS trigger AS'
> > begin
> >     If new.shipment_type_id = 4 then
> >         --do something
> >     end if;
> >     return new;
> > end;
> >  in the above example everything works if shipment_type_id is being
> > updated.  If it is not I will receive a run-time error because
> > shipment_type_id is not part of the record new.

All the fields of updated record must available in NEW variable.  Refer
the manual for details. Forward your sql & run-time error for further 
assistance.

regards,
bhuvaneswaran