Re: custom serial number

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 <andreas(dot)kretschmer(at)schollglas(dot)com> wrote:

> From: A. Kretschmer <andreas(dot)kretschmer(at)schollglas(dot)com>
> Subject: Re: [SQL] custom serial number
> To: "mahmoud ewiwi" <mahmoud_ewiwi(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)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