title: Why does daterange function not exist?
body: <p>I tried the below postgresql command in my C# (Net Core 2.2 + npgsql 4.0.6):</p>
  
  <pre><code>string _sql = "select * from user_branch_rotation where daterange(start_date, end_date,'[)') &amp;&amp; daterange('2019-02-10','2020-05-11') and users_pid=4 and branch_pid=2"
  
  var _q = await _conn.QueryAsync(_sql , new { });
  </code></pre>
  
  <p>but it returns </p>
  
  <blockquote>
    <p>"Function daterange(timestamp without time zone, timestamp without
    time zone) does not exist"</p>
  </blockquote>
  
  <p>note. I tried the above postgresql command on pgadmin and it works properly.</p>
  
  <p>Has anybody experienced this?</p>