This time to the mailinglist !!
Hi Ivan,
My mistake. I made a stupid mistake and blogged a working solution. Sorry for
the inconvenience. If you see any improvements on that approach, please do let
me know !!!
http://robbypelssers.blogspot.nl/2012/06/regular-xquery-versus-xquery-using.html
Kind regards,
Robby
From: Ivan Shcheklein [mailto:[email protected]]
Sent: Thursday, June 14, 2012 3:44 PM
To: Robby Pelssers
Cc: [email protected]
Subject: Re: [Sedna-discussion] question related to using index scan
Hi Robby,
It should work. Give us some details:
- full query (how do you call getBasicTypes)
- what that query returns (empty sequence, error?)
Ivan Shcheklein,
Sedna Team
Hi all,
I created a index on 1 collection for testing purpose.
create index "basictype_id"
on fn:collection("basicTypes/released")/Product
by @identifier
as xs:string
Using the index like below works just fine:
index-scan("basictype_id", "PH3330L", "EQ")
But now I had the idea of using the index-scan to quickly return a sequence of
Products like below:
declare function local:getBasicTypes($productIds as xs:string*) as
element(Product)* {
for $id in $productIds return index-scan("basictype_id", $id, "EQ")
};
That unfortunately does not work as index-scan can only work with literal
values apparently. Or am I missing something here?
But is what I am trying to accomplish here possible in some way? I find it
hard believe that the above use case is not wanted by most of us.
Thx in advance,
Robby Pelssers
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Sedna-discussion mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and
threat landscape has changed and how IT managers can respond. Discussions
will include endpoint security, mobile security and the latest in malware
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Sedna-discussion mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sedna-discussion
