|
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
|
