title: function does not exists in postgreSQL .. Why ?
body: <p>Need your help please , can't understand why i got the following error , i am not a professional postgresql developer .. </p>
  
  <p>As you can see the function created , so why the function not exist occurred ? </p>
  
  <pre><code>create or replace function loginAttempt (u_email character varying, u_password character varying, date_time timestamptz, OUT attempt smallint) returns smallint AS $$
     BEGIN
          INSERT INTO login_attempts (typed_password, date_time, attempt_nu, email) VALUES (u_password, date_time, attempt_nu, email);
          IF attempt = 3 THEN INSERT INTO warnings (u_email,u_password) VALUES (u_email,u_password);
          END IF;
     END;
  $$ LANGUAGE plpgsql;
  
  
    select loginattempt ('Jon.Jones88@gmail.com','+_@kjhfdb987', now(), 1);
  </code></pre>
  
  <blockquote>
    <p>ERROR:  function loginattempt(unknown, unknown, timestamp with time zone, integer) does not exist
    LINE 1: select loginattempt ('Jon.Jones88@gmail.com','+_@kjhfdb987',...
                   ^
    HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
    SQL state: 42883
    Character: 8</p>
  </blockquote>
  
  <p><a href="https://i.stack.imgur.com/io1EL.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/io1EL.png" alt="enter image description here"></a></p>