True. It does seem more proper. Thanks.
On Sat, 11 Dec 2004 10:57:25 -0700, Michael Fuhr <[EMAIL PROTECTED]> wrote: > 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/ > -- ICQ: 1912453 AIM: VitalyB1984 MSN: [EMAIL PROTECTED] Yahoo!: VitalyBe ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
