title: Select where in multiple pairs - postgresql
body: <p>I want to find all rows that match a list of pairs (multiple columns) and my query is not working. I get results if I only have a list of either column, but not when they are paired.</p>
  <pre><code>SELECT * FROM table
  WHERE (name,age) IN (('john',23),('jane',50),('john',44))
  </code></pre>
  <p>I saw posts about using EXISTS but I don't know how to convert this query.</p>
  <p>I checked my database and it should return 8 rows but it is returning an empty table</p>