Hi,
I have a question regarding function overloading:
assume that you have a function that takes several numeric arguments -
lets for example say 4 arguments: f(a,b,c,d)
Now further assume that internally in the function the first thing you
do is to convert the arguments to double precision, do your calculations
and return the result always in double precision.
In order to allow for all combinations of numeric
(int2,int4,int8,float4,float8) inputs one would now have to define and
write 5^4 = 625 functions !!!!!!!!!!!!!!!
Apart from forcing the function user to use casts, is there any other
way to avoid this madness of writing 625 functions ?
Thanks
Robert
---------------------------(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
match
