All pastes #2082034 Raw Edit

Unnamed

public text v1 · immutable
#2082034 ·published 2011-09-22 04:24 UTC
rendered paste body
id | 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