Re: function overloading

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: function overloading
Дата
Msg-id 7740.1136838516@sss.pgh.pa.us
обсуждение исходный текст
Ответ на function overloading  (Robert Greimel <greimel@ing.iac.es>)
Ответы Re: function overloading  (Robert Greimel <greimel@ing.iac.es>)
Список pgsql-general
Robert Greimel <greimel@ing.iac.es> writes:
> 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 ?

I don't see why you need more than one function, taking all
double-precision arguments ...

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: help with rules for system table
Следующее
От: Matthew Peter
Дата:
Сообщение: Re: plpgsql question