Postgres Pro
Downloads
Home   >   mailing lists

independent sequence for each month - Mailing list pgsql-sql

From Tomasz Myrta
Subject independent sequence for each month
Date
Msg-id 3F3B29C6.6050101@klaster.net
Whole thread Raw
Responses Re: independent sequence for each month
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Jesse Scott
Date:
Subject: Re: Timezone troubles
Next
From: Tom Lane
Date:
Subject: Re: Timezone troubles