Re: custom serial number - Mailing list pgsql-sql

From Gerardo Herzig
Subject Re: custom serial number
Date
Msg-id 492306CD.9040007@fmed.uba.ar
Whole thread Raw
In response to Re: custom serial number  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
A. Kretschmer wrote:
> am  Tue, dem 18.11.2008, um  1:09:44 -0800 mailte mahmoud ewiwi folgendes:
>> hi gurus
>> i have a problem in generating serial number with the form yyyymm0000 how can i do that?
> 
> test=# create temporary sequence foo;
> CREATE SEQUENCE
> test=# select to_char(current_date,
> 'yyyymm')||trim(to_char(nextval('foo'),'09999'));
>   ?column?
> -------------
>  20081100001
> (1 row)
> 
Thats nice. You should now take care about changing months.
I guess a cron job can do the job restarting the sequence the first day
of the month. (If we are talking about Unix/Linux, off course)

Gerardo


pgsql-sql by date:

Previous
From: "Pavel Stehule"
Date:
Subject: Re: custom serial number
Next
From: "Ryan Wells"
Date:
Subject: Left Join Question