How to add a column to a table?

Question

PostgreSQL

I make a select with a union and a select, but I need the second select to take expired date_death_lines into the table on the right column where executor == executor add the task column For
now, like this:

Answer 1

Seems like it works

SELECT tt1.*,string_agg(tt.task,E'\n') as oldtask FROM table_tasks tt1 join table_tasks  tt on tt1.executor=tt.executor and (tt1.date_death_line>now() and tt.date_death_line<now()) group by tt1.id;