Postgres query to create combinations

Question

I have a table like this -

tableCountry

I want to write a query to list out the following combinations -

>USA-UK
>USA-Germany
>UK-USA
>UK-Germany
>Germany-USA
>Germany-UK

Is such a combination listing possible through postgresql?

Thanks.

Readers will also want to look at stackoverflow.com/q/31175335/398670 which is a follow-up of this one. — Craig Ringer
– Craig Ringer, Commented Jul 3, 2015 at 4:47

klin · Accepted Answer · 2015-06-30 04:39:52Z

2

This is as simple as:

SELECT t1.Country || '-' || t2.Country
  FROM table t1
  JOIN table t2 ON t1.Country <> t2.Country;

klin

123k15 gold badges240 silver badges262 bronze badges

answered Jun 30, 2015 at 4:38

Mike K

4863 silver badges7 bronze badges

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

1 Answer 1