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

Posted to users@jackrabbit.apache.org by Gadbury <ga...@googlemail.com> on 2010/03/11 14:19:33 UTC

SQL2 - select distinct

Is select distinct supported in JCR_SQL2?

If not, are there plans to incorporate it?  At present, I am iterating using
a row iterator and adding the column value to a set.  I'm not sure this is
the best or fastest method.
-- 
View this message in context: http://n4.nabble.com/SQL2-select-distinct-tp1588932p1588932.html
Sent from the Jackrabbit - Users mailing list archive at Nabble.com.

Re: SQL2 - select distinct

Posted by Alexander Klimetschek <ak...@day.com>.

On Thu, Mar 11, 2010 at 14:19, Gadbury <ga...@googlemail.com> wrote:
> Is select distinct supported in JCR_SQL2?

No, it is not supported. See the JCR 2.0 spec [1] (not mentioned).

[1] http://www.day.com/specs/jcr/2.0/6_Query.html#Column

Regards,
Alex

-- 
Alexander Klimetschek
alexander.klimetschek@day.com