Re: Squences with letters aswell as numbers

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