In the specification doc 0.16.2 the following methods are defined for QueryResult: QueryResult.getPropertyNames(), QueryResult.getRows() and QueryResult.getNodes() (page 110). But in the page 112 it says "The column names of the table are returned by QueryResult.getColumnNames". it should say getPropertyNames(), or am I missing something?
in 8.6.3 SQL EBNF it says
"select ::= SELECT ('*' | proplist )"
So it seems jcr doesn't support any kind of expression nor function in the select clause.
e.g. something like "SELECT concat(myapp:myprop1, myapp:myprop2) as customColumn from myapp:mynodetype" would be really handy. And it could be retrieved with QueryResult.getColumnName("customColumn"). What do you think?
regards edgar
