Hi, 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. regards, Christiaan -- 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.
