[GENERAL] [Triggers] Check if OLD or NEW records are NULL

2006-10-26 Thread macieh
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:=''INSE

[GENERAL] External variable

2006-08-22 Thread macieh
and log with triggers what each user do with data rows. Thanks in advance. -- macieh ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org