Postgres Pro
Downloads
Home   >   mailing lists

Re: How to generate unique invoice numbers for each day - Mailing list pgsql-general

From Jorge Godoy
Subject Re: How to generate unique invoice numbers for each day
Date
Msg-id AANLkTikLJ6Obct==F7QyH45r7XijrU9L0bLaQN+qctaT@mail.gmail.com
Whole thread Raw
In response to How to generate unique invoice numbers for each day  ("Andrus Moor" <kobruleht2@hot.ee>)
Responses Re: How to generate unique invoice numbers foreach day
List pgsql-general
Tree view
Use a sequence.

--
Jorge Godoy     <jgodoy@gmail.com>


2011/1/15 Andrus Moor <kobruleht2@hot.ee>
Invoice numbers have format  yymmddn

where n is sequence number in day staring at 1 for every day.

command

SELECT COALESCE(MAX(nullif(substring( substring(tasudok from 7), '^[0-9]*'),'')::int),0)+1
FROM invoice
where date= ?invoicedate

is used to get next free invoice number if new invoice is saved.

If multiple invoices are saved concurrently from different processes, they will probably get same number.

How to get unique invoice number for some day in 8.1+ when multiple users create new invoices ?

Andrus.

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: "Andrus Moor"
Date:
Subject: How to generate unique invoice numbers for each day
Next
From: "Andrus Moor"
Date:
Subject: Re: How to generate unique invoice numbers foreach day