Hi,

I'm trying to find an HQL statement for Hibernate 2.1.8/Oracle10g/Postgres that finds all entities whose collection of names matches a list of names (named parameter :names); the result set should only contain entities that have *all* names passed; pseudo HQL:

from Entity e where :names all in elements( e.names )

:categories is of type String[]. The above statement isn't valid, and I wonder whether I can do this via expressions, or whether I have to use subselects?

Thanks in advance.