Postgres Pro
Downloads
Home   >   mailing lists

select only 1 pair - Mailing list pgsql-sql

From Shaozhong SHI
Subject select only 1 pair
Date
Msg-id CA+i5Jwa5VR7vJ=9S-9-d_3HgxQ_MmqwLW9+vqeN=jNDUVSVCHQ@mail.gmail.com
Whole thread Raw
Responses RE: select only 1 pair  ("Voillequin, Jean-Marc" <Jean-Marc.Voillequin@moodys.com>)
Re: select only 1 pair  (William Alves Da Silva <william_silva@unochapeco.edu.br>)
Re: select only 1 pair  (Frank Streitzig <fstreitzig@gmx.net>)
Re: select only 1 pair  (Thomas Kellerer <shammat@gmx.net>)
AW: select only 1 pair  (Stöcker, Martin <Martin.Stoecker@etl-datenservice.de>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: hubert depesz lubaczewski
Date:
Subject: Re: How to do things like \timing on in a do loop?
Next
From: Stöcker, Martin
Date:
Subject: AW: select only 1 pair