Re: JCR-SQL2 UNION

Hi,

On Mon, Oct 3, 2011 at 10:46 AM, Paulo Carapinha
<paulocarapinha <at> gmail.com> wrote:
> Thanks for the reply, there is a way to check if a property does not exist
> in a JCR-SQL2 statement?

Yes, see the "IS NOT NULL" and "IS NULL" constraints [1].

[1] http://www.day.com/specs/jcr/2.0/6_Query.html#6.7.18%20PropertyExistence

BR,

Jukka Zitting