Federico Travaglini <federico.travaglini@aubay.it> writes: > This funcion in used as a column in a select on about 400k records > If I leave the highlighted row it takes 27 seconds, otherwise 14 seconds! > Such behaviour looks not to be reasonable.
It's not at all clear which line you think is the "highlighted" one.
Its the comparison of the double input value to the untyped literal ‘NaN’ (the first case test).