db-jdo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christiaan <christiaan...@hotmail.com>
Subject subquery: max & size()
Date Thu, 21 Feb 2008 15:14:15 GMT

a question about subqueries. With the subquery spec, should it be possible
to execute the following filter, which should return the nodes with the
maximum children?

"children.size() == (select max(node.children.size()) from x.y.Node node)"

I am asking this since the size() is probably translated into a count() and
I don't believe it is allowed to perform an aggregate on another aggregate
in sql.

View this message in context: http://www.nabble.com/subquery%3A-max---size%28%29-tp15613074p15613074.html
Sent from the JDO - Development mailing list archive at Nabble.com.

View raw message