Home > mailing lists

select only 1 pair - Mailing list pgsql-sql

From	Shaozhong SHI
Subject	select only 1 pair
Date	October 24, 2022 14:44:03
Msg-id	CA+i5Jwa5VR7vJ=9S-9-d_3HgxQ_MmqwLW9+vqeN=jNDUVSVCHQ@mail.gmail.com Whole thread Raw
Responses	RE: select only 1 pair Re: select only 1 pair Re: select only 1 pair Re: select only 1 pair AW: select only 1 pair
List	pgsql-sql

There are pair ids. Each pair is repeated.

id1 id2

1 2

2 1

3 4

4 3

How to only select 1 unique pair for each?

Regards,

David

From: hubert depesz lubaczewski
Date: 16 October 2022, 09:21:35
Subject: Re: How to do things like \timing on in a do loop?

From: Stöcker, Martin
Date: 24 October 2022, 14:51:26
Subject: AW: select only 1 pair