Re: updating(column) Porting from Oracle Trigger to PostgreSQL trigger

2021-02-05 Thread Laurenz Albe
On Fri, 2021-02-05 at 10:57 +0530, Jagmohan Kaintura wrote: > When we do an implementation from Oracle to PostgreSQL in trigger for clause > like : > updating(column_name) ==> (TG_OP='UPDATE' and OLD.column_name IS > DISTINCT FROM NEW.column_name) > But this condition would mostly not be

updating(column) Porting from Oracle Trigger to PostgreSQL trigger

2021-02-04 Thread Jagmohan Kaintura
Hi Team, When we do an implementation from Oracle to PostgreSQL in trigger for clause like : updating(column_name) ==> (TG_OP='UPDATE' and OLD.column_name IS DISTINCT FROM NEW.column_name) But this condition would mostly not be sufficient when we are updating any column and with similar val