Postgres Pro
Downloads
Home   >   mailing lists

Re: custom serial number - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: custom serial number
Date
Msg-id 20081119074519.GA17709@a-kretschmer.de
Whole thread Raw
In response to Re: custom serial number  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Responses Re: custom serial number
List pgsql-sql
Tree view 
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
ido 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

pgsql-sql by date:

Previous
From: Mark Roberts
Date:
Subject: Re: Left Join Question
Next
From: mahmoud ewiwi
Date:
Subject: Re: custom serial number