need sequence as A1 A2 in postgres

Question

Dear all, Using sequence we can insert a sequence of integers in postgers
like that I just want to insert A1 and A2 , Is this possible to do this in a straight forward manner , or otherwise do need to write a function ?

Please let me know the easiest way of doing this Thanks in advance !

PostgreSQL version? Sample schema? Anything?

Pointy
– Pointy

2010-10-29 13:02:17 +00:00
Commented Oct 29, 2010 at 13:02 — Pointy
– Pointy, Commented Oct 29, 2010 at 13:02

Tometzky · Accepted Answer · 2010-10-29 14:45:34Z

1

create table test ( a text );

CREATE TABLE

insert into test(a) select 'A'||generate_series(1,4)::text;

INSERT 0 4

select * from test;

 a  
----
 A1
 A2
 A3
 A4
(4 rows)

answered Oct 29, 2010 at 14:45

Tometzky

24.2k5 gold badges64 silver badges79 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

need sequence as A1 A2 in postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related