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
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