title: Auto increment depending on value of column in PostgreSQL
body: <p>The question follows, can I auto increment (verification_number) depending on a value of a specific column (here business_uuid) so that verification_number increments by one (1) depending on that business_uuid's own highest number of verification_number?</p>
  
  <p>Database looks as follows:
  table: verification</p>
  
  <pre><code>verification_id = integer, sequence (Primary Key)
  business_uuid = text
  verification_number = integer
  </code></pre>
  
  <p>The verification_id is the Primary Key in this table and I want the verification_number to follow it's own auto increment depending on what it's highest value is filtered only for business_uuid.</p>
  
  <p>The business_uuid is a unique identifier for each business. </p>
  
  <p>Is it possible?</p>