How to move column value to new column in Postgresql?

Question

i would like to create table from

SELECT 
a.value_text, 
a.value_free_text,
a.value_date,
a.value_number
FROM survey_user_input_line a 
LEFT JOIN survey_label b on b.id = a.value_suggested
WHERE a.survey_id = %s
ORDER BY question_id, a.user_input_id,  id, value_suggested_row

to

can anybody tell me how to code it

Tim Biegeleisen · Accepted Answer · 2021-02-08 04:16:00Z

1

You may use a chained call to COALESCE, making sure to cast all columns to a common data type (text makes the most sense here):

SELECT *, COALESCE(value_text, value_free_text, value_date::text,
                   value_number::text) AS all_value
FROM yourTable;

answered Feb 8, 2021 at 4:16

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

Collectives™ on Stack Overflow

How to move column value to new column in Postgresql?

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