Re: Arrays - selecting (and not removing) duplicates...

[Pól Ua Laoínecháin <linehanp@xxxxxx>]

Hi all and apologies for the simple question!

> I want to "feed" the result of a query into your function - is there
> something special I have to do for this?

SELECT
  ARRAY_DUPS
  (
    (
      SELECT ARRAY[1,3,4,1, 5,6,5, 67]
    )
  ) AS t;

answer:

t
{1,5}


And I can also feed in queries. A second set of braces (round
brackets) is needed!

Thanks again and rgs,


Pól...

> Pól...