Re: How to generate unique invoice numbers foreach day

Why would you do that?

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

--
Jorge Godoy <jgodoy(at)gmail(dot)com>

On Sat, Jan 15, 2011 at 17:09, Andrus Moor <kobruleht2(at)hot(dot)ee> 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 <jgodoy(at)gmail(dot)com>
> *To:* Andrus Moor <kobruleht2(at)hot(dot)ee>
> *Cc:* pgsql-general(at)postgresql(dot)org
> *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 <jgodoy(at)gmail(dot)com>
>
>
> 2011/1/15 Andrus Moor <kobruleht2(at)hot(dot)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(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>>
>
>