SEO
vBulletin Search Engine Optimization
| |||||||
![[Triggers] Check if OLD or NEW records are NULL](http://unixadmintalk.com/iconimages/f36/triggers-check-if-old-new-records-null_ltr.gif)
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-09-2008, 12:03 PM
| ||||
| ||||
 [Triggers] Check if OLD or NEW records are NULL Dear All, Can I check if OLD record is NULL in trigger function. I'm using tg_op and check if it's UPDATE, etc. but I need check if OLD record exists. Is it possible? f.i. -------------------------------------------- IF OLD IS NOT NULL THEN IF OLD.identity IS NULL THEN tg_op_final:=''INSERT''; ELSE tg_op_final:=''UPDATE''; END IF; ELSE tg_op_final:=''FILL_BY_DATALOADER''; END IF; ------------------------------------------- Thanks! -- Best Regards Maciek      |
Linear Mode
