Dennis Bjorklund <[EMAIL PROTECTED]> writes: > Is NULL above an empty statement in oracle or is it a normal expression
It's an actual empty statement. > (the normal NULL value) so that the above is a shorthand for > WHEN OTHERS THEN SELECT NULL; Even if it were, the point here is to accept standard Oracle coding without any translation of that sort. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match