Thanks, Marcel. We have another doubt, though. Say we want to search for a phrase (exact match) on a property(name, in the example), we'd use something like
select * from nt:base where name='The Ooga Booga' We now want to make this case insensitive such that select * from nt:base where name='the ooga booga' return the same result as the first query. How could we do this? Thanks, Sidu. On 27/10/06, Marcel Reutegger <[EMAIL PROTECTED]> wrote:
yes, you can. but keep in mind that this is highly jackrabbit specific (and even specific to the current query handler implementation) and not specified in jsr 170. If jackrabbit will use a different index implementation in the future it might happen that this will not be supported anymore. select * from nt:base where contains(name, '"Ooga Booga"~3') regards marcel C. K. Ponnappa wrote: > Hi, > > Is there a way I can use Lucene syntax in jackrabbit SQL to include > proximity searches? > I need to do something like: > > select * from nt:base where (name:'Ooga Booga' )~3 > > so I get all nodes where the name property has the terms 'Ooga' and > 'Booga' within 3 words of one another. > > > Thanks, > Sidu. > >
