Re: Comparing arrays

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Comparing arrays
Date: 2005-10-03 09:53:18
Message-ID: 20051003095318.GB1342@kaufbach.delug.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

A Gilmore <agilmore(at)shaw(dot)ca> schrieb:

> Hello,
>
> Id like to compare two arrays, and if any value is found in both, return
> true. Is this possible without needing a procedure to loop through one?
>
> For example, say categories is an array :
>
> SELECT * FROM t1 WHERE ANY(ARRAY[5,7,9]) = ANY(categories);

Nice question. I have written a little function. You can see this on
http://a-kretschmer.de/tools/array_compare.sql.
Let me know if you have a better solution.

Regards, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bruce Momjian 2005-10-03 13:47:39 Re: Transaction within plpgsql
Previous Message Andreas Kretschmer 2005-10-03 06:52:10 Re: Importing Later Release.....