Hello...
... and a good monday morning to everyone :-)!
Iam currently trying to create an index for string values in lower-case.
Consider the following document:
<doc>
<word xml:id="w1">ABC</word>
<word xml:id="w2">abc</word>
</doc>
A case-sensitive Index could be written as follows:
CREATE INDEX "ws" ON collection("texts")//word BY child::text() AS xs:string
If one wants to implement case-insensitive queries I would try to index values
which have been converted to lower-case:
CREATE INDEX "ws" ON collection("texts")//word BY fn:lower-case(child::text())
AS xs:string
Sadly, the BY-expression does not seem to allow function calls(?)
The direct query works though:
collection("texts")//word[fn:lower-case(child::text())="abc"]
Returns both ABC and abc.
Has anybody had the same problem and found a solution or a workaround?
Best regards,
Peter
------------------------------------------------------------------------------
Are you an open source citizen? Join us for the Open Source Bridge conference!
Portland, OR, June 17-19. Two days of sessions, one day of unconference: $250.
Need another reason to go? 24-hour hacker lounge. Register today!
http://ad.doubleclick.net/clk;215844324;13503038;v?http://opensourcebridge.org
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
