Andreas Kretschmer wrote:
> A Gilmore <agilmore(at)shaw(dot)ca> schrieb:
>>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
> Let me know if you have a better solution.
> Regards, Andreas
Thank you for the reference, the use of array_upper() is quite useful.
Apparently there is no straight-forward way to do it in SQL, so I ended
up writing a similiar plpgsql function.
- A Gilmore
In response to
pgsql-novice by date
|Next:||From: Andrew Borley||Date: 2005-10-04 10:56:54|
|Subject: grant select on all tables|
|Previous:||From: operationsengineer1||Date: 2005-10-03 23:02:20|
|Subject: Re: Trouble Connecting to DB After PGAdmin3 1.2.2 pgsql 7.4.5 Backup and 8.03 Restore - SOLVED w/ QUESTION |