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
doit programatically?
Mahmoud Al-Ewiwi
Al-Mahawer
Hebron- Palestine
--- On Wed, 11/19/08, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:
> From: A. Kretschmer <andreas.kretschmer@schollglas.com>
> Subject: Re: [SQL] custom serial number
> To: "mahmoud ewiwi" <mahmoud_ewiwi@yahoo.com>, 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