Re: No function matches the given name and argument types.

2023-01-16 Thread Christophe Pettus
> On Jan 16, 2023, at 09:53, David G. Johnston > wrote: > > I don't see any good way to say: "given this function signature, and the fact > it cannot be found, what are the next closest function signatures that are > present". I can see a use-case for such functionality, though: A "did

Re: No function matches the given name and argument types.

2023-01-16 Thread David G. Johnston
On Mon, Jan 16, 2023 at 10:42 AM arons wrote: > Why the error happen is clear to me, in the example is also easy to see > that the 7th parameter is the problem. > But I'm searching a more general way to find easily which of the parameter > is the problem. > Suppose you have a function with 30

Re: No function matches the given name and argument types.

2023-01-16 Thread Pavel Stehule
Hi po 16. 1. 2023 v 18:42 odesílatel arons napsal: > Why the error happen is clear to me, in the example is also easy to see > that the 7th parameter is the problem. > But I'm searching a more general way to find easily which of the parameter > is the problem. > Suppose you have a function with

Re: No function matches the given name and argument types.

2023-01-16 Thread arons
Why the error happen is clear to me, in the example is also easy to see that the 7th parameter is the problem. But I'm searching a more general way to find easily which of the parameter is the problem. Suppose you have a function with 30 parameters with mixed sort of types. They only way I know

Re: No function matches the given name and argument types.

2023-01-16 Thread Adrian Klaver
On 1/16/23 08:17, Adrian Klaver wrote: On 1/16/23 08:04, arons wrote: Dear All, I'm facing a general problem and I'm looking the best, fastest, way how to identify the problem and solve it. As example assume we have a function like that: CREATE OR REPLACE FUNCTION testBinding01 ( p_in01

Re: No function matches the given name and argument types.

2023-01-16 Thread Adrian Klaver
On 1/16/23 08:04, arons wrote: Dear All, I'm facing a general problem and I'm looking the best, fastest, way how to identify the problem and solve it. As example assume we have a function like that: CREATE OR REPLACE FUNCTION testBinding01 ( p_in01 bigint, p_in02 bigint, p_in03 bigint,