>>> where a <> b or (a is null and b is not null) or (a is not null and >>> b is null) >> >> In the absence of IS DISTINCT FROM, I think this has the same semantics: >> >> where coalesce(a, b) <> coalesce(b, a) > > sorry, but no.
So it would have to be where coalesce(a, b, 0) <> coalesce(b, a, 0) for your example with ints, and likewise some default value for other column types... -- Scott Ribe [EMAIL PROTECTED] http://www.killerbytes.com/ (303) 722-0567 voice ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
