title: Is there a function in MonetDB that is equivalent to IF?
body: <p>I need to do something like this in MonetDB:</p>
  
  <pre><code>select
    If(value &gt; 0, value, -1) as selected_value
  from
    table
  </code></pre>
  
  <p>In mysql, this means 'return value if value > 0, otherwise return -1.'
  Is there an equivalent function to this in MonetDB?</p>
  
  <p>And I am not looking for a case statement. I know it exists in both MonetDB and other sql languages. I would like specifically to know of something like the example I gave.</p>
  
  <p>Thank you</p>