independent sequence for each month

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: PGSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: independent sequence for each month
Date: 2003-08-14 06:18:46
Message-ID: 3F3B29C6.6050101@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi
I have to generate unique numbers starting from 1 every month. I can't
reset sequence on last day of month, because sometimes I have to insert
some future or past values. I thought I can create independent sequence
for each month, but it doesn't sound elegant.

Regards,
Tomasz Myrta

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Jomon Skariah 2003-08-14 08:19:05 Re: Porting from PL/SQL to PLPGSQL
Previous Message Jesse Scott 2003-08-14 04:59:10 Re: Timezone troubles