From: | "Robert B(dot) Easter" <reaster(at)comptechnews(dot)com> |
---|---|
To: | "Brian C(dot) Doyle" <bcdoyle(at)mindspring(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Sequence Help |
Date: | 2001-01-17 21:18:09 |
Message-ID: | 0101171618090A.02219@comptechnews |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Wednesday 17 January 2001 14:53, Brian C. Doyle wrote:
> Hello all,
>
> How would I setup a sequence that would reflect, for example, abc-0001?
reaster=# create sequence bb;
CREATE
reaster=# select 'abc-' || lpad(nextval('bb'), 4, '0');
?column?
----------
abc-0001
(1 row)
lpad truncates on the right if the string number gets longer than 4 digits.
You'll have to create the sequence, then do something like:
reaster=# create table ttt ( id text default ('abc-' || lpad(nextval('bb'),
4, '0')) );
CREATE
reaster=# insert into ttt default values;
INSERT 2836131 1
reaster=# insert into ttt default values;
INSERT 2836132 1
reaster=# insert into ttt default values;
INSERT 2836133 1
reaster=# insert into ttt default values;
INSERT 2836134 1
reaster=# insert into ttt default values;
INSERT 2836135 1
reaster=# insert into ttt default values;
INSERT 2836136 1
reaster=# insert into ttt default values;
INSERT 2836137 1
reaster=# select * from ttt;
id
----------
abc-0013
abc-0014
abc-0015
abc-0016
abc-0017
abc-0018
abc-0019
(7 rows)
--
-------- Robert B. Easter reaster(at)comptechnews(dot)com ---------
-- CompTechNews Message Board http://www.comptechnews.com/ --
-- CompTechServ Tech Services http://www.comptechserv.com/ --
---------- http://www.comptechnews.com/~reaster/ ------------
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2001-01-17 21:21:07 | Re: Re: JDBC Performance |
Previous Message | Joseph Shraibman | 2001-01-17 20:58:35 | Re: pg_log |