On 6/30/07, Bruno Wolff III <[EMAIL PROTECTED]> wrote:
The following is just FYI. I was recently doing some stuff with greatest() on oracle (9.2.0.8.0) and noticed that it returned null if ANY of the arguments were null. Out of curiosity I checked postgres' definition of that function and found that it returns null only if ALL of the arguments are null.
W/o knowing the SQL standard (just from what I'd perceive as sensible) I'd say Oracle is broken. :}
-- Cheers, Andrej ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match