<body>
<div align="left"><font face="Arial"><span style="font-size:10pt">Hi All</span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">i have problem in Trigger functoin</span></font></div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">when trigger fire then ERROR
massage is</span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">ERROR : Attribute 'UNDEF00'
not found</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">PostgreSQL status:PGRES_FATAL_ERROR</span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">here UNDEF00 is by defult value of
po_no</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"><b>TRIGGER IS</b></span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">CREATE TRIGGER add_stock_gr_trig AFTER
UPDATE on gr FOR EACH
ROW execute procedure add_stock_gr_fun(); </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">my function is this</span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">create function add_stock_gr_fun()
returns opaque as'</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">DECLARE</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> rec RECORD; </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> txtpo varchar; </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">BEGIN</span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">IF NEW.po_no <> "UNDEF00"
THEN </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> SELECT
INTO rec gr_no, noofbags, final_wt, matl_cd </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> FROM
po p, gr g</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> WHERE
g.po_no=p.po_no and g.gr_no=NEW.gr_no; </span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> IF
OLD.po_no #= "UNDEF00" THEN</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> UPDATE
matl_mst </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> SET
bal_bag = bal_bag + rec.noofbags, </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> bal_kg = bal_kg + rec.final_wt </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> WHERE
matl_mst.matl_cd = rec.matl_cd; </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> ELSE</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> UPDATE
matl_mst </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> SET
bal_bag = bal_bag + NEW.noofbags - OLD.noofbags, </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> bal_kg = bal_kg + NEW.final_wt -
OLD.final_wt</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> WHERE
matl_mst.matl_cd = rec.matl_cd; </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> </span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt"> END
IF;</span></font></div>
<div align="left"><font face="Arial"><span style="font-size:10pt">END IF;</span></font></div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">return NULL; </span></font></div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">END;' language 'plpgsql'; </span></font></div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">please Help me</span></font></div>
<div align="left"><br>
</div>
<div align="left"><br>
</div>
<div align="left"><font face="Arial"><span style="font-size:10pt">Ramesh Patel</span></font></div>
<div align="left"></div>
</body>