jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Doug Douglass" <douglass.d...@gmail.com>
Subject SQL equivalent of Node.hasProperty?
Date Wed, 23 Aug 2006 22:23:23 GMT
I thought I knew the answer but I'm unable to get it right:

  If a node type baz is defined as having an optional property foo:bar
(STRING), and I want to find all such nodes without a foo:bar property
actually stored (i.e., Node.hasProperty("foo:bar") == false), I would expect
that one of the following would work:

  1. SELECT * FROM baz WHERE foo:bar IS NULL;

  2. SELECT * FROM baz WHERE foo:bar = '';

But niether does.


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