No function matches the given name and argument types.

From: arons <arons7(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: No function matches the given name and argument types.
Date: 2023-01-16 16:04:14
Message-ID: CA+XOKQBOGd_wd8aaUxoKt7GNruHd=5cKN4uQicX7oBmDMk9kDA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,

p_in04 bigint,

p_in05 bigint,

p_in06 bigint,

p_text7 text

) RETURNS text

LANGUAGE sql

AS $$

select 'ciao';

$$;

I can call the function in some of the variant below:

select testBinding01(1,2,3,4,5,6,7);

select testBinding01(p_in01 => 1,p_in02 => 2,p_in03 => 3,p_in04 => 4,p_in05
=> 5,p_in06 => 6,p_text7 => 7);

select testBinding01(p_in01 => 1,p_in02 => 2,p_in03 => 3,p_in04 => 4,p_in05
=> 5,p_in06 => 6,p_text9 => 'some txt');

All of the above, produce the error:

*No function matches the given name and argument types.*

My question is: how is the best way to identify the problem?

Is a parameter name? is a parameter type? is the function name?

An especially in case is a parameter type how is the easy way to identify
which parameter is causing the problem?

In case a function has a lot of parameters (and in even worst case has some
overloading) going trough all parameters to check its type/name costs a lot
of time.

Thanks for any help

Renzo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2023-01-16 16:17:29 Re: No function matches the given name and argument types.
Previous Message Joe Conway 2023-01-16 15:47:54 Re: glibc initdb options vs icu compatibility questions (PG15)