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.
Hi Hubert, and thanks for your input!
> > I was just wondering if there is some (already written) function out
> > there that will drop this functionality into my lap?
> #v+
> create function array_dups(ANYARRAY) returns ANYARRAY as $$
> select array( select i from unnest($1) i group by i hav
On Mon, Aug 30, 2021 at 01:47:19PM +0100, Pól Ua Laoínecháin wrote:
> I was just wondering if there is some (already written) function out
> there that will drop this functionality into my lap?
Sure, here:
#v+
create function array_dups(ANYARRAY) returns ANYARRAY as $$
select array( select i
Hi all,
Suppose I have two arrays (TEXT, INT - not important - prefer INT) as follows:
x = {1, 4, 5, 6, 6, 7, 8, 9, 9, 9, 9, 10, 12, 12}
I would like a result of:
y = {6, 9, 12}
I'm aware of the UNNEST function and that I can convert the array into
rows and do a COUNT(blah) HAVING COUNT(blah)
