On Sat, Dec 11, 2004 at 08:54:40AM -0800, Stephan Szabo wrote: > old.series_id IS DISTINCT FROM new.series_id may do what you want > depending on how you want NULLs to compare (IS DISTINCT FROM would be > false).
I forgot about IS DISTINCT FROM. I like that better than using COALESCE, as I had suggested. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
