Argument casting hierarchy?
От | Wells Oliver |
---|---|
Тема | Argument casting hierarchy? |
Дата | |
Msg-id | CAOC+FBVZzMgF5u91E8sFUPht_8s+Xy5PVxWQ1qncgZLCkM4sMQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Argument casting hierarchy?
Re: Argument casting hierarchy? |
Список | pgsql-general |
Hi guys, hoping you can help clarify what the 'hierarchy' of casts might be in function arguments.
Meaning I have the following two functions
stats.foo1 (a bigint, b bigint) returns a/b::numeric
stats.foo1 (a real, b real) returns a/b::numeric
It's essentially the same function, but I thought I had to create two to accept the different types.
However, when I call stats.foo1(3::smallint, 4::smallint) I receive the old:
ERROR: function stats.foo(smallint, smallint) is not unique
Along w/ the message to explicitly cast.
I am essentially trying to write one function that will cast "down", I guess, anything smaller than what's passed. I am guessing I only need the real/real argument signature, but I wanted some clarity from the group.
I appreciate it.
В списке pgsql-general по дате отправления: