Re: custom serial number - Mailing list pgsql-sql

From Pavel Stehule
Subject Re: custom serial number
Date
Msg-id 162867790811180145j6ce64db5x9a7d2ed39562af92@mail.gmail.com
Whole thread Raw
In response to Re: custom serial number  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-sql
Hello

2008/11/18 A. Kretschmer <andreas.kretschmer@schollglas.com>:
> am  Tue, dem 18.11.2008, um 10:37:23 +0100 mailte Pavel Stehule folgendes:
>> Hello
>>
>> what do you wont to do exactly?
>>
>> you can try -
>>
>> create sequence s;
>> postgres=# create sequence s;
>> CREATE SEQUENCE
>> postgres=# select to_char(current_date, 'yyyymmdd') ||
>> trim(to_char(nextval('s'), '0000'));
>>    ?column?
>> --------------
>>  200811180002
>> (1 row)
>
> What's wrong with your sequence, it starts with 2?
>

missing lines :)

>
> SCNR *g*
>
> Andreas
> --
> Andreas Kretschmer
> Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
> GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net
>
> --
> Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-sql
>


pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: custom serial number
Next
From: Gerardo Herzig
Date:
Subject: Re: custom serial number