"George Pavlov" <gpavlov@xxxxxxxxxxxxxx> writes: >> From: David Fetter [mailto:david@xxxxxxxxxx] >> This case statement returns true when z factorial is zero, so I'd >> recommend the SQL standard <> or IS NOT DISTINCT FROM instead. > i do hate potential ambiguity... the != was something stuck in my brain > from old sybase, i think. i always liked != ("not equals") as more > intuitive than <> ("less than, greater than"???), but i will have to > change my ways, especially if "the standard" says so. The notion that != might be scanned as two operators whereas <> would not be is nonsense. I assume David was just joking. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster