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);
Obviously this doesn't work, but you can kinda see what Im trying to do.
Thank you for any insight,
- A Gilmore
pgsql-novice by date
|Next:||From: Andreas Kretschmer||Date: 2005-10-03 06:52:10|
|Subject: Re: Importing Later Release.....|
|Previous:||From: Tom Lane||Date: 2005-10-03 01:18:17|
|Subject: Re: Vacuum analyse 8.0.3 |