Combine rows in postgres

Question

I have a table with the following columns: date, type, area, district I want the select output to look like this: date, type1_area, type2_area, district I understand the first step is a groupby over date and district but I don’t know how to combine the values into a single row.

Any help will be greatly appreciated.

Please include some sample input data, along with the output you would expect. — Tim Biegeleisen
– Tim Biegeleisen, Commented May 30, 2019 at 9:23

Tim Biegeleisen · Accepted Answer · 2019-05-30 09:27:22Z

2

Your textual description seems to imply that you want a query along these lines:

select
    date,
    string_agg(type || '_' || area, ', ' order by type) type_area,
    district
from your_table
group by
    date,
    area,
    district;

answered May 30, 2019 at 9:27

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

Combine rows 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