| From: | "A(dot)Bhuvaneswaran" <bhuvan(at)symonds(dot)net> |
|---|---|
| To: | achill(at)matrix(dot)gatewaynet(dot)com |
| Cc: | Dmitri Fuerle <ffo2lp(at)yahoo(dot)com>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Question regarding triggers |
| Date: | 2003-10-20 13:31:43 |
| Message-ID: | Pine.LNX.4.44.0310201856130.11594-100000@Bhuvan.bksys.co.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-10-20 13:48:52 | Re: Question regarding triggers |
| Previous Message | achill | 2003-10-20 13:22:39 | Re: Question regarding triggers |