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 1qI9tY-00089K-CD for pgsql-sql@arkaria.postgresql.org; Sat, 08 Jul 2023 15:30:48 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qI9tX-0008Em-7S for pgsql-sql@arkaria.postgresql.org; Sat, 08 Jul 2023 15:30:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qI9tW-0008Ed-VK for pgsql-sql@lists.postgresql.org; Sat, 08 Jul 2023 15:30:46 +0000 Received: from mail-lf1-x12c.google.com ([2a00:1450:4864:20::12c]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qI9tU-002jDQ-D1 for pgsql-sql@lists.postgresql.org; Sat, 08 Jul 2023 15:30:45 +0000 Received: by mail-lf1-x12c.google.com with SMTP id 2adb3069b0e04-4fba8f2197bso4725101e87.3 for ; Sat, 08 Jul 2023 08:30:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688830242; x=1691422242; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=XJQWbSeR4cmT/a8KvXu/eFMkncU/8o5AUmZ0OAJArpk=; b=VOpUTVNyW9YL43vNCvNMhHd4oN5U4ba6WetHKNU7a2smJrBLpE5MHCtWszhY1/zPdW Nx8zaC1OojgXJOLV5C8qrr4TQ/Z/jpxl8AMuD9CPABR9TlNRGK8MWkEmqBqlT9XnM10b Mn3jUbePphNm2yGLYq6mXETKBIwTwOGLvpxyXDth0eQt6PD6yFP7+avtgscQOpcjbil7 4a9LnvuJFbIwDgmNg/qIalyoQ04tHWy2TI1uAwkFD2I/Ngl6uNypNj27z0Hwk3ubS7bN hPzaf+mJrxWZs9aPQ7cWoP9EjNhi4J5/Os5WGqyik+6L1i65F7dC6MF09+SxJjW6E1Ky pfqg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688830242; x=1691422242; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=XJQWbSeR4cmT/a8KvXu/eFMkncU/8o5AUmZ0OAJArpk=; b=Q8pJAjnf6iiRtDXlCJqJuTlVezHxz68RqKO4h18L0NMYj9PUt+jgpgou9H7AThTiHZ RVrWuGH5kYMPEZ48Av/Jjn2JWRKWIx7BuybD1qcmAKQaYMLdTfbBUre3o1uUHfNEN6vI 9yPbo8Padzvd0EsOzmyHjNziT0k8pPf3lyzcyRX9KsSOMpSdS1n4+vx+8Nz476aIM2b+ NcaifiJOHKnqftP0MtXoCd9SuvPXkfDpVPuSGrvGDftoVnoThJcrxSC5g5Sh+6QTIi+z vl8cqO5MBkXgMifRnE81BfWQHmvZmMR+hHiVlbueb0UaDfUsKvvFKeUbB4aHyTIRt1Tr tE0w== X-Gm-Message-State: ABy/qLY6Kbxshr81UVzepGzVKp9Xv8cKFZVGbQrqf2yf4ELT2otw6xw0 qTgKLG2fQjy773clwvWaQDVW/jFbFTWhUFt/D3IQkkrX X-Google-Smtp-Source: APBJJlF4l3phuLQXlL+HzJEYuLOWSnoH6dydBH0jVURAr1B0ZYBAYZgQ252MmNP2bWwMORGnwaJNBk+tW4O3gT/s6b0= X-Received: by 2002:a05:6512:e9c:b0:4f8:7325:bcd4 with SMTP id bi28-20020a0565120e9c00b004f87325bcd4mr7043281lfb.0.1688830242135; Sat, 08 Jul 2023 08:30:42 -0700 (PDT) MIME-Version: 1.0 From: Shaozhong SHI Date: Sat, 8 Jul 2023 16:30:31 +0100 Message-ID: Subject: How to remove duplicates in an array and maintain the order? To: pgsql-sql Content-Type: multipart/alternative; boundary="000000000000ab238905fffb6ef6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ab238905fffb6ef6 Content-Type: text/plain; charset="UTF-8" How to remove duplicated values in an array and maintain the order? Regards, David --000000000000ab238905fffb6ef6 Content-Type: text/html; charset="UTF-8"
How to remove duplicated values in an array and maintain the order?

Regards,

David
--000000000000ab238905fffb6ef6--