"Andrej Ricnik-Bay" <andrej.groups@xxxxxxxxx> writes: > On 6/30/07, Bruno Wolff III <bruno@xxxxxxxx> wrote: >> 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. :} Hmm ... I fear Oracle's behavior is more correct, because if any argument is null (ie, unknown), then who can say what the greatest or least value is? It's unknown (ie, null). But I suspect our behavior is more useful. Comments? regards, tom lane
