Search Postgresql Archives

Re: How to generate unique invoice numbers foreach day

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Why would you do that?

You can always reset the sequence at the end of the day.

--
Jorge Godoy     <jgodoy@xxxxxxxxx>


On Sat, Jan 15, 2011 at 17:09, Andrus Moor <kobruleht2@xxxxxx> wrote:
There are 365 days in year.
Do you really think pre-creating sequence for every day for every year is best solution ?
 
Andrus.
----- Original Message -----
Sent: Saturday, January 15, 2011 8:41 PM
Subject: ***SPAM*** Re: How to generate unique invoice numbers foreach day

Use a sequence.

--
Jorge Godoy     <jgodoy@xxxxxxxxx>


2011/1/15 Andrus Moor <kobruleht2@xxxxxx>
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux