Thanks for the help. I discovered my error while coming up with a better example.
Thanks,
Dmitri
"A.Bhuvaneswaran" <bhuvan@symonds.net> wrote:
> 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.
