At the moment I'm using this kind of sequence to provide a primary key
for some of my tables

create sequence group_seq;
select setval('group_seq', (select max(group_ID) from groups));

However I'd like to create a sequence that has this kind of output

g1
g2
g3
g4
g5

where g doesn't change

and

u1
u2
u3

where u doesn't change

is there are simple way of doing this?

On Tue, Feb 28, 2006 at 08:46:45AM -0800, NubeY wrote:
> create sequence group_seq;
> select setval('group_seq', (select max(group_ID) from groups));
>
> However I'd like to create a sequence that has this kind of output
>
> g1
> g2
> g3
> g4
> g5
>
> where g doesn't change

Any reason you can't append the sequence value to a string as in
the following example?

CREATE SEQUENCE foo_seq;

CREATE TABLE foo (
id text PRIMARY KEY DEFAULT 'f' || nextval('foo_seq'),
val text NOT NULL
);

INSERT INTO foo (val) VALUES ('a');
INSERT INTO foo (val) VALUES ('b');
INSERT INTO foo (val) VALUES ('c');

SELECT * FROM foo;
id | val
----+-----
f1 | a
f2 | b
f3 | c
(3 rows)

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Thankyou you're a lifesaver.