Re: Sequence on a char(6) column
От
Jaime Casanova
Тема
Re: Sequence on a char(6) column
Дата
Msg-id
c2d9e70e0512140626g769f7d90weaefa48014c87d95@mail.gmail.com
Ответ на
Sequence on a char(6) column (Roland Giesler)
Список
Дерево обсуждения
Sequence on a char(6) column "Roland Giesler" <roland@giesler.za.net>
Re: Sequence on a char(6) column Bruno Wolff III <bruno@wolff.to>
Re: Sequence on a char(6) column Bruno Wolff III <bruno@wolff.to>
Re: Sequence on a char(6) column "Roland Giesler" <roland@giesler.za.net>
Re: Sequence on a char(6) column Bruno Wolff III <bruno@wolff.to>
Re: Sequence on a char(6) column Jaime Casanova <systemguards@gmail.com>
On 12/14/05, Roland Giesler wrote:
> Is it possible to create a sequence like 'ABC012','ABC013', etc. in a
> char(6) column?
>
i guess you can do something like:
create sequence seq1;
create table tt (
...
fld1 char(6) default 'str' || nextval('seq1'),
...
);
--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)
В списке pgsql-novice по дате отправления
