Thank you very much, it works fine with me , but how can i restart the sequence at the start of each month, or should i do it programatically?
Mahmoud Al-Ewiwi Al-Mahawer Hebron- Palestine --- On Wed, 11/19/08, A. Kretschmer <[EMAIL PROTECTED]> wrote: > From: A. Kretschmer <[EMAIL PROTECTED]> > Subject: Re: [SQL] custom serial number > To: "mahmoud ewiwi" <[EMAIL PROTECTED]>, pgsql-sql@postgresql.org > Date: Wednesday, November 19, 2008, 9:45 AM > am Tue, dem 18.11.2008, um 20:56:07 -0800 mailte mahmoud > ewiwi folgendes: > > Thank you hery much, it works fine with me , but how > can i restart the sequence at the start of each month, or > should i do it programatically? > > Please answer to the list and not to me. > > You can write a function for that. First, check if is a new > month and > create a new sequence or reset the sequence. > > > Andreas > -- > Andreas Kretschmer > Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: > -> Header) > GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA > http://wwwkeys.de.pgp.net -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
