Hello,
I have not Oracle, so I cannot test it, but PostgreSQL implementation
respect Oracle:
http://archives.postgresql.org/pgsql-patches/2005-06/msg00431.php
Regards
Pavel Stehule
2007/6/30, Bruno Wolff III <bruno@wolff.to>:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>