Re: [SQL] Question regarding triggers

2003-10-20 Thread Dmitri Fuerle
  Thanks for the help.  I discovered my error while coming up with a better example.     Thanks,   Dmitri"A.Bhuvaneswaran" <[EMAIL PROTECTED]> wrote: > Why dont you try to write your trigger in C?Hi, one cannot write triggered procedures in C. Currently, it can only bewritten in plpsgql.> > CREATE

[SQL] Question regarding triggers

2003-10-20 Thread Dmitri Fuerle
     I'm writing a trigger but running into problems.  My problem is that I can not determine anyway to tell what fields are in the *new* record.  Without knowing what fields are there I get runtime errors if that's not what is being updated example:   CREATE FUNCTION "public"."check_shipment" ()