• Register
1 vote

Problem :

Getting following error while executing function
no function matches the given name and argument types. you might need to add explicit type casts.
6.9k points

1 Answer

0 votes

Solution :

Error message says that a function call is only matched by an existing function if all its arguments are of the same type and passed in same order. 

So suppose if the next f() function

create function f() returns integer as $$ 
    select 1;
$$ language sql;

is called as

select f(1);

It will throw error out with

ERROR:  function f(integer) does not exist
LINE 1: select f(1);
So no function matches the given name and argument types. You might need to add explicit type casts.

because there is no f() function that takes an integer as argument.

So you need to carefully compare what you are passing to the function to what it is expecting. 

36.1k points

Related questions

0 votes
1 answer 16 views
Problems: Can anyone give the right solution You need to add a role to a VM in an offline state. How do you proceed? a. Start the VM, mounting the virtual hard disk (VHD). Then add the role. b. Create a new VHD with the added role. Replace the old VHD with the new VHD. c. Install the role to the VHD while still offline. d. Add the role to a different VM.
asked Feb 14 maddi86 5.4k points
1 vote
1 answer 12 views
Problem: Hello guys, I am a novice in the programming world. I&rsquo;ve started learning with the C/C++ language. I&rsquo;ve got a piece of C++ code with two classes. The program is throwing a compile-time error does not name a type I am ... receiveMessage(); vector<Message> *dataMessageList; }; I am looking forward to having a legitimate solution to the problem. Thanks for your kind concern
asked Apr 29 Gavin 15.2k points
1 vote
1 answer 12 views
Problem: Can anyone guide me with the right solution as I am new and learning programming? Write the code to call the function named send_signal. there are no parameters for this function?
asked Feb 18 maddi86 5.4k points
0 votes
2 answers 52 views
Problem : I am trying to create the table but facing below error &ldquo;Error: There is no unique constraint matching given keys for referenced table.&rdquo; How to fix the above error?
asked Jan 21 jwilliam 3.9k points