jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Miguel Prieto <jmpr...@gmail.com>
Subject SELECT [DISTINCT] ... Removal of duplicate rows
Date Mon, 31 Jan 2011 14:10:32 GMT
Sorry to bring up a question that has already been asked but the truth is I
haven't found a straight (and convincing) answer yet.

JCR-SQL2 doesn't provide a SELECT DISTINCT (or similar, AFAIK). Neither do
SQL or XPATH in JCR 1.0... How are people getting around this?.  What's the
best way of removing duplicate rows?

I read that someone was iterating over the results and putting them in a
Set. In my case, because of the possible huge number of results, that
approach may end up being too costly.

Thanks. Regards,

Miguel Prieto

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message