Re: custom serial number

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: mahmoud ewiwi <mahmoud_ewiwi(at)yahoo(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: custom serial number
Date: 2008-11-19 07:45:19
Message-ID: 20081119074519.GA17709@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message mahmoud ewiwi 2008-11-19 08:52:07 Re: custom serial number
Previous Message Richard Huxton 2008-11-19 07:45:07 Re: Left Join Question