Invoice increment

From: Søren Frisk <soeren(dot)frisk(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Invoice increment
Date: 2020-02-26 08:38:57
Message-ID: CACe3Kr6jhD4BKv74bs7f3K6FDq7KM_QvCy3s35Dm8gfi5By9Xg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all

I'm trying to find a way to increment an invoice number. And i think it
would be pretty straight forward just using a SERIAL int. But as we're
selling across multiple countries, i need the invoice increment to be reset
by a country_id. any good way to achieve this in a dynamic way?
Hope this is the right place to ask.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2020-02-26 08:40:21 Re: Highly academic: local etcd & Patroni Cluster for testing on a single host
Previous Message Ian Barwick 2020-02-26 08:27:22 Re: Highly academic: local etcd & Patroni Cluster for testing on a single host