[SQL] Question regarding triggers

[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" () 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.
 
Please help,
Dmitri
 
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search

Re: [SQL] Question regarding triggers

[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 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. Referthe manual for details. Forward your sql & run-time error for further assistance.regards,bhuvaneswaran
Do you Yahoo!?
The New Yahoo! Shopping - with improved product search