Re: Sequence on a char(6) column - Mailing list pgsql-novice

On 12/14/05, Roland Giesler <roland@giesler.za.net> 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 ;)