Re: How to remove duplicates in an array and maintain the order?

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Shaozhong SHI <shishaozhong(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: How to remove duplicates in an array and maintain the order?
Date: 2023-07-08 15:36:19
Message-ID: CAKFQuwZNe3AhmsBqswShSBT5TNvw3tgvCvegQvHZE7voJ+g9XQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, Jul 8, 2023 at 8:30 AM Shaozhong SHI <shishaozhong(at)gmail(dot)com> wrote:

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

Use a for loop in pl/pgsql.

David J.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Marcos Pegoraro 2023-07-08 15:50:54 Re: How to remove duplicates in an array and maintain the order?
Previous Message Shaozhong SHI 2023-07-08 15:30:31 How to remove duplicates in an array and maintain the order?