Pavel Stehule <[EMAIL PROTECTED]> writes:
+                       /* If any argument is null, then result is null (for 

Are you sure about that?  The only reference I could find says that
these functions are not strict in Oracle:
on page 2-185:

 The NULL keyword can appear in the list but is ignored. However, not all 
 value expressions can be specified as NULL. That is, a non-NULL value 
 expression must be in the list so that the data type for the expression
 can be determined. 
 The GREATEST and LEAST functions can result in NULL only if at run time 
 all value expressions result in NULL. 

The strict interpretation is mathematically cleaner, no doubt, but
offhand it seems less useful.

                        regards, tom lane

---------------------------(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

Reply via email to