Re: [Hibernate] Binary Expressions in Collections

[Christian B. <chr...@bl...>]

On 22 Nov (11:54), Gavin King wrote:

> then I will understand your requirements better. As far as I can tell, what
> you would really want is either
> 
> select foo from my.Foo
>      where "baz%" like all foo.bar.elements
> 
> or
> 
> select foo from my.Foo
>      where "baz%" like some foo.bar.elements

Hm, this is equivalent for this purpose. This would be the SQL
(simplified):

Table FOO { FOO_OID, BAR_OID }
Table BARS { BAR_OID, POSN, VALUE }

select a.FOO_OID from FOO a, BARS b
    where a.BAR_OID = b.BAR_OID
    and b.VALUES like "baz%"

-- 
Christian Bauer
tu...@in...