title: error: bind message supplies 1 parameters, but prepared statement "" requires 0
body: <p>I have a table 'article' with column 'content' .I want to query Postgresql in order to search for a string contained in variable 'temp'.This query works fine-</p>
  
  <pre><code>pool.query("select * from article where upper(content) like upper('%some_value%')");
  </code></pre>
  
  <p>But when I use placeholder $1 and [temp] in place of some_value , I get the above error - </p>
  
  <pre><code>pool.query("select * from article where upper(content) LIKE upper('%$1%')",[temp] );
  </code></pre>
  
  <p>Note - Here $1 is a placeholder and should be replaced by the value in [temp] , but it treats '%$1%' as a string , I guess. Without the quotes ' ' , the LIKE operator doesn't work. I have also tried the query - </p>
  
  <pre><code>pool.query("select * from article where upper(content) LIKE upper(concat('%',$1,'%'))",[temp] );
  </code></pre>
  
  <p>to ensure $1 is not treated as a string literal but it gives the error - 
      error: could not determine data type of parameter $1</p>