Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1omz4V-0001h6-A5 for pgsql-sql@arkaria.postgresql.org; Mon, 24 Oct 2022 15:08:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1omz4T-0002WM-RF for pgsql-sql@arkaria.postgresql.org; Mon, 24 Oct 2022 15:08:57 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1omz4T-0002WC-I4 for pgsql-sql@lists.postgresql.org; Mon, 24 Oct 2022 15:08:57 +0000 Received: from mout.gmx.net ([212.227.15.18]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1omz4R-0006Eg-Ek for pgsql-sql@lists.postgresql.org; Mon, 24 Oct 2022 15:08:57 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=gmx.net; s=badeba3b8450; t=1666624134; bh=mencJbGi72TtBiq3OCDy3PFuh0ZXhK+h8Nzevn2cH2s=; h=X-UI-Sender-Class:Subject:To:References:From:Date:In-Reply-To; b=hifb8TwfHvoRMdxPmvo5NtyS4r8wOJii8pxmnZezTw0/ZQJs/L4T69gf8unoTM5zi FFW1VkSxuD/fA0JhhlR0AzcgjRMuJkLHIpmQOWJUvksX3kfgerF1bNBPW0INU8Y7N0 N8OeGwJO3OZboEW0QE9tTgYgUFUteOSH5fSVawlo= X-UI-Sender-Class: 01bb95c1-4bf8-414a-932a-4f6e2808ef9c Received: from [192.168.178.20] ([83.171.167.213]) by mail.gmx.net (mrgmx005 [212.227.17.190]) with ESMTPSA (Nemesis) id 1MD9T1-1ow1d10mQL-0096h2 for ; Mon, 24 Oct 2022 17:08:54 +0200 Subject: Re: select only 1 pair To: pgsql-sql@lists.postgresql.org References: From: Thomas Kellerer Message-ID: Date: Mon, 24 Oct 2022 17:08:52 +0200 User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de; rv:1.8.1.21) Gecko/20090302 Thunderbird/2.0.0.21 Mnenhy/0.7.5.666 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Language: de-DE Content-Transfer-Encoding: quoted-printable X-Provags-ID: V03:K1:e9uK2JqGtQMfX8GQoANyC8YpeKdZfujBOlHeq7zy1x3UzKpRyBj irCRPV/Scq6y13z95T7WJ9Eh4IXQKkq3Q4HAIgx5znxbJ6C2cAwSCKv/wsf2Pypm9J72Es/ cKxzw2SxfRo4mpv/EUSHZwF1ja4f49W0bl9r4KHSR6Y7TqzS9qbyoWsx+74d5kvHcAX0HxD BZkL2OU8HpGEf553B71hQ== X-Spam-Flag: NO X-UI-Out-Filterresults: notjunk:1;V03:K0:JylxpGa/9Mk=:OxL219rV7zeb6guE6T0Pj2 TmqxVAxFcaqdVSXfgTBKkkOU1tJRHmalOldZywZUKtgO3DKKwjjRDrc2HlkeH1MwZmZTr9WRE zf+i289NTPXWNH6tCJMOs2TCIb4N8Q8fuGAPxxIsnrS8digKkYJbzLcdvItsJe87DXjYnuWtL WcSvG8a2Ni+d2zgO/EhZ+sdWvoOkb0l5yMvY6Cwhss8xlP4pbSti8Q7HD3k93McyHICTT+lVS QCkAwTaYUX0YZ/URZSNdEFq1gVjMmQ1CVeWgUbS9HB9JVUYsp0+qy5QNPhhUVgsjGI+KdKqnS 9j2k7XHsvdqCb4aX7aW/Z0k3G2vAJJp3BorEfrlHJnpz6fDUcE2LKQyLz7SLLSRlD+1Ia2dM+ 0++H504mQJ2Y+1DxJES7QkfXWmuKSAvR2gxZktLd9xT9rwjjaSHFgdj342OxNDbJy4wMj51Uz NnqvtjX0W3Lhe6krARfLk82hv4pNLD+/kHSj2bWMZmTrVTpC1ZLFTiU5Ap4kwSId9TvNZkpx6 w8MAwhx5F8cOaQNr9DJZ6JkLLz5VDsyQPdlCO3zJJW08tm1BKQF/05lLyb2PmcY/rUYA43iW0 kQNWxLEioyOV1cioq7Sgan2SkP2exlXvURNyyvcv87V27oMNSoFXpVY/r3zxsXhGY9JqK5Js7 qIk79oASq1gCAA9DLp10sxzHQ9mqpwPEuBgqEkxz8j3mUFZlxihnb2EZKSAOWXYMXeaU+5AUD onI/tPTLX1NRcFZBcw7pO2UnyyFB2j6dlK51OAwn2+iH+xAJCMBp+C77y/XNpJh5bO1ONOKH0 sSzwhvwDd6Qzjfe5j96pR/Y24vb6Yxl79rLNFjcqL1NQT+BpnKAJWgSmGKUMiho/RYzWs4wYP 47ukfa7NJ8xKej+YcDIIWgEr8oPvQozkPh5tfeFY4vm1XuVtyOnNFSvFAauTDS2r7EypO7eUT qpytEds9DlBGvo04EVNwzQCJhw+rNooTXnqXQlUvaSmlVMfRJF5PrO77Ahs1rC4ZZsbPMdVka ECgmD7TUejUvqrExCRktK6ZlBulhGJtESLwRA6y7x98FU/CZYJOUbf4aZyOWBCIRgnqfoYRIm UPS21nOyarWhpTJdbIg2KVsdJTKa3vM7w6wdGX53yW8lXUYRXRYpv/9VYJd8b38gBbWpbnSP6 BY/Vv+N97YFw8RkTtMGx3g9kb6ksZJGHtKSsAfa05ndgae9sWhXxZ9L5EAdmM9A2E61pMl+qO 2nUBSuO3RqfebWZOEVto4biCc46Iij82zU+CcXnYh0ZY0aDk9Il7r/yK8T9MM1cWak0xpoLwn YbSLbR2fqg4VOAuNR2tpFNTY7fAnOt69OzW66TaZX934PuzDwBi5fGX0KD9xSbLn66db6TwJL YVOhJM3HyESX2fInLz2SO1Uh8cmpToY1/7daa5Zath7jS7U+sBaWUznXGOyelf9V+O+jt3XJc TZV5Wz78vgC4RLEWcu2okouPQRARwMrkb+/9kIp8vaS6NyLtZAXB0K4pXoJtpnwGxIQyL3yci jxpSTRqfbr9qnJC3LNfsh7HjG1fgENWzfNcsCxRpuJy8+ List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Shaozhong SHI schrieb am 24.10.2022 um 16:44: > There are pair ids.=C2=A0 Each pair is repeated. > > id1=C2=A0 =C2=A0id2 > 1=C2=A0 =C2=A0 =C2=A0 =C2=A02 > 2=C2=A0 =C2=A0 =C2=A0 =C2=A0 1 > 3=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A04 > 4=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A03 > > How to only select 1 unique pair for each? select distinct least(id1,id2), greatest(id1,id2) from the_table