On Sat, 15 Jan 2011, Andrus Moor wrote:
There are 365 days in year. Do you really think pre-creating sequence for every day for every year is best solution ?
Andrus, I just saw this thread so my idea may not work for you. What I'd do is use the Julian date (that is, the sequential day from 1-365/6) followed by 1, 2, or 3 digits depending on how many invoices are generated each day. Makes sorting and comparisons simple. Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
