I find myself wishing I had a syntax "LIKE ANY (array['foo','bar'])".
I don't see much value in the = ANY, = ALL, <> ANY, <> ALL syntax since they're equivalent more or less to IN and NOT IN. But it could be neat if other operators were supported. As it turns out this isn't immediately relevant, it will only be relevant when one day the database drivers use the binary FE protocol and support binding arrays directly. Then I could pass an application-level array to postgresql as an array directly. Currently I think it would still have to be quoted which would mean I may as well just pass a fixed maximum number of search elements anyways. Unless there's a better option I haven't thought of. -- greg ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
