Why would you do that? You can always reset the sequence at the end of the day.
-- Jorge Godoy <[email protected]> On Sat, Jan 15, 2011 at 17:09, Andrus Moor <[email protected]> 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 ----- > *From:* Jorge Godoy <[email protected]> > *To:* Andrus Moor <[email protected]> > *Cc:* [email protected] > *Sent:* Saturday, January 15, 2011 8:41 PM > *Subject:* ***SPAM*** Re: [GENERAL] How to generate unique invoice numbers > foreach day > > Use a sequence. > > -- > Jorge Godoy <[email protected]> > > > 2011/1/15 Andrus Moor <[email protected]> > >> 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 ([email protected]) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> > >
