You are viewing a plain text version of this content. The canonical link for it is here.

Posted to users@jackrabbit.apache.org by Miguel Prieto <jm...@gmail.com> on 2011/01/31 15:10:32 UTC

SELECT [DISTINCT] ... Removal of duplicate rows

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