title: stored procedure postgres and php
body: <p>I am currently having trouble in regards of my stored procedure.</p>
  
  <p>I have this stored procedure, under the schema <strong>main</strong>:<br /><br />
  <code>register(LOGIN_ID varchar, PASSWORD varchar)</code><br /><br />
  I am trying to call this in a query but I got no luck,<br /></p>
  
  <pre><code>$query = "SELECT main.register('test','pass123')";
  $run = $pg_query($conn, $query);
  </code></pre>
  
  <p>This returns an error that <strong><em>No function matches the given name and argument types. You might need to add explicit type casts.</em></strong> 
  <br /><br />
  Any insights please. Thanks.</p>