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 <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1qI9zN-0008Qu-IA
	for pgsql-sql@arkaria.postgresql.org; Sat, 08 Jul 2023 15:36:49 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-sql-owner+archive@lists.postgresql.org>)
	id 1qI9zM-0006HQ-D9
	for pgsql-sql@arkaria.postgresql.org; Sat, 08 Jul 2023 15:36:48 +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 <david.g.johnston@gmail.com>)
	id 1qI9zM-0006Ex-4D
	for pgsql-sql@lists.postgresql.org; Sat, 08 Jul 2023 15:36:48 +0000
Received: from mail-ed1-x534.google.com ([2a00:1450:4864:20::534])
	by magus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <david.g.johnston@gmail.com>)
	id 1qI9zC-002vnh-QJ
	for pgsql-sql@lists.postgresql.org; Sat, 08 Jul 2023 15:36:47 +0000
Received: by mail-ed1-x534.google.com with SMTP id
 4fb4d7f45d1cf-51e29913c35so4061597a12.0
        for <pgsql-sql@lists.postgresql.org>;
 Sat, 08 Jul 2023 08:36:38 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20221208; t=1688830597; x=1691422597;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:from:to:cc:subject:date:message-id:reply-to;
        bh=HQBBrpqM51b3K/+W4AQH/CjksCO0KeELcyllwce2spI=;
        b=nm3u/PR91mP70OKqS5FXfAeAz5webZlPhcVBXAwSj1+avV8jbcWjtawSDK9QnzjxoP
         KtrS7NeOBZHGiWHH03XCJmCU9zChyojpbJCNS42vbxvrcdsduTTqFcIssGrWEJwkSBKg
         GfpS0lnGTkM0b54RWlyyD8HEgMccvK8snA1TwMXKSshOmC2N/Qphx344E8GgHZViuNEx
         1AVxTK9UyNsYl64SaVDAuYXjTRDybJCstCKWB28ekmxj5BloG8H8/aSeG0rjWqpDrPNu
         ZtBVS7+EvLr6q2ImXNopxQNrV2CyKWzfdXJXfpf0Uo5jDPhRZeZyz0txmmweJcbjXb9k
         ZuiQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20221208; t=1688830597; x=1691422597;
        h=cc:to:subject:message-id:date:from:in-reply-to:references
         :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id
         :reply-to;
        bh=HQBBrpqM51b3K/+W4AQH/CjksCO0KeELcyllwce2spI=;
        b=c0vJEImB4VtaFVioMFYiqq0aUqfkHv8N16c9OVrUVz34HQ3dhUPhnqnynTDRp4+6Hx
         EvvxGXeKpSPHS+/hmujkKV5YcIA7Wdl1Wd1cuV0IsttxkWi2apAgjS0oANcLmZ8CLEBA
         9DToOM5PncQrT27xOJ1GUwTwO36Pz4HXnLvfJq4DyyN4TVJlg++7k4XXQoi6pdim+/90
         0nWs1sZjKP8TCZs8xHdEjJyei3ybanGpAC/m+SdDCHgxQXNzRIpijJLKmGu4iM2ImDkn
         iJC01F4WscQdQz/sQUqIOUmvYc95uzmuASiTC2xxzpfBebd+dKa8taGtk93uDAyxglqk
         65ng==
X-Gm-Message-State: ABy/qLYpkZA6CLSHuJkqclWM6aYBgOy8UzSgRTdDumM080U8wq6TwbSr
	7XwnHG/fRpPMVZY7PJgX5+eke2ZqYVZpHw2/Ozs=
X-Google-Smtp-Source: 
 APBJJlFi+K5l5uIGDhnWTVJhhyWzknVvNR5KztixOE1j1BR/566pHoWzI0JJzRBAmaXF2jK+AWXDUcG0Z6KNwAwfQTM=
X-Received: by 2002:a05:6402:350:b0:51d:9682:e30c with SMTP id
 r16-20020a056402035000b0051d9682e30cmr6805822edw.5.1688830597082; Sat, 08 Jul
 2023 08:36:37 -0700 (PDT)
MIME-Version: 1.0
References: 
 <CA+i5JwbwFsa2nHM+MG4mXinxx_fEzQGPrpUcz=T8yGDWPQrmnw@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwbwFsa2nHM+MG4mXinxx_fEzQGPrpUcz=T8yGDWPQrmnw@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Sat, 8 Jul 2023 08:36:19 -0700
Message-ID: 
 <CAKFQuwZNe3AhmsBqswShSBT5TNvw3tgvCvegQvHZE7voJ+g9XQ@mail.gmail.com>
Subject: Re: How to remove duplicates in an array and maintain the order?
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000d3338005fffb8321"
List-Id: <pgsql-sql.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-sql@lists.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-sql>
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwZNe3AhmsBqswShSBT5TNvw3tgvCvegQvHZE7voJ%2Bg9XQ%40mail.gmail.com>
Precedence: bulk

--000000000000d3338005fffb8321
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Sat, Jul 8, 2023 at 8:30=E2=80=AFAM Shaozhong SHI <shishaozhong@gmail.co=
m> wrote:

> How to remove duplicated values in an array and maintain the order?
>

Use a for loop in pl/pgsql.

David J.

--000000000000d3338005fffb8321
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Sat, Jul 8, 2023 at 8:30=E2=80=AFAM Shaozhong SHI &lt;<=
a href=3D"mailto:shishaozhong@gmail.com">shishaozhong@gmail.com</a>&gt; wro=
te:</span><br></div></div><div class=3D"gmail_quote"><blockquote class=3D"g=
mail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204=
,204,204);padding-left:1ex"><div dir=3D"ltr">How to remove duplicated value=
s in an array and maintain the order?</div></blockquote><div><br></div><div=
 class=3D"gmail_default" style=3D"font-family:arial,helvetica,sans-serif">U=
se a for loop in pl/pgsql.</div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=3D=
"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"></div></di=
v></div>

--000000000000d3338005fffb8321--