title: How do I convert an interval into a number of hours with postgres?
body: <p>Say I have an interval like</p>
  
  <pre><code>4 days 10:00:00
  </code></pre>
  
  <p>in postgres. How do I convert that to a number of hours (106 in this case?) Is there a function or should I bite the bullet and do something like</p>
  
  <pre><code>extract(days, my_interval) * 24 + extract(hours, my_interval)
  </code></pre>