Unnamed
public text v1 · immutableid | param_id | value
1 1 foo
1 2 bar
2 1 baz
2 2 qux
--> 1, 'foo-bar'
--> 2, 'baz-qux'
Try this:
SELECT
tn1.value || '-' || tn2.value
FROM
table_name tn1, table_name tn2
WHERE
tn1.id = tn2.id AND tn1.param_id != tn2.param_id