title: Why order of results varies when querying table pg_enum in Postgres?
body: <p>Yesterday I queried PostgreSQL's <a href="https://www.postgresql.org/docs/current/catalog-pg-enum.html" rel="nofollow noreferrer">pg_enum</a> table:</p>
  
  <pre><code>SELECT enumlabel FROM pg_enum
  </code></pre>
  
  <p>The <code>enumlabel</code>s were returned in the order of the <code>enumsortorder</code>.</p>
  
  <p>Today I run the same query, but the <code>enumlabel</code>s were returned in the <em>alphabetical order</em> of the <code>enumlabel</code>.</p>
  
  <p>What would have caused this to happen?</p>