title: PostgreSQL - sort by UUID version 1 timestamp
body: <p>I am using <a href="https://en.wikipedia.org/wiki/Universally_unique_identifier#Version_1_(date-time_and_MAC_address)" rel="nofollow noreferrer">UUID version 1</a> as the primary key. I would like to sort on UUID v1 timestamp. Right now if I do something like this:</p>
  <pre><code>SELECT id, title 
  FROM table 
  ORDER BY id DESC;
  </code></pre>
  <p>PostgreSQL does not sort records by UUID timestamp, but by UUID string representation, which ends up with unexpected sorting result in my case.</p>
  <p>Am I missing something, or there is not a built in way to do this in PostgreSQL?</p>