Return to Question

Version: PostgreSQL 13.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit

Playtime:

https://dbfiddle.uk/-zHbXWwP

fiddle

In the previous SQL snippet, I manually defined the static column names. These should based on x values & hence dynamic.

Thoughts?

Playground:

In the previous SQL snippet, I manually defined the static column names.

These should be based on x values & hence 'dynamic' matching below

select array (select distinct x from data order by x)

| x_campaigns               |
| ------------------------- |
| ["1","2","3","4","5","6"] |

Thoughts?

Playtime: