PostgreSQL 9.5: comma separated string using string_agg()

Question

I have the following table with two fields.

Table:

CREATE TABLE str_agg
(
cola varchar(50),
colb varchar(50)
);

Records:

insert into str_agg values('Alex','Student');
insert into str_agg values('Mak','Student');
insert into str_agg values('John','Teacher');
insert into str_agg values('Tony','Teacher');

I want to display the result in the comma separated format like as shown below:

Expected Result:

result
---------------------------------------------------------
Alex(Student),Mak(Student),John(Teacher),Tony(Teacher)

My try:

select string_agg(cola,'('||colb||'),') Result
from str_agg;

Getting result:

result
---------------------------------------------------------
Alex(Student),Mak(Teacher),John(Teacher),Tony

Why not generate full string first cola || '(' || colb || ')' and than pass it to string_agg with ',' delimiter ? — user1516873
– user1516873, Commented Mar 24, 2017 at 8:44

user330315 · Accepted Answer · 2017-03-24 08:44:37Z

3

You are passing the value '('||colb||'),' as the delimiter.

You want:

select string_agg(cola||'('||colb||')', ',') Result
from str_agg;

answered Mar 24, 2017 at 8:44

user330315

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

Collectives™ on Stack Overflow

PostgreSQL 9.5: comma separated string using string_agg()

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related