[xquery-talk] query on recursive xml structure

[Torsten Grust]

Hi,

does

   //b[*/tokenize(.," ") = ("kiwi","banana")]

solve your problem?  (It behaves as desired for the two cases you  
give below.)

Cheers,
    --Torsten

On Aug 29, 2006, 10:18 AM, yix yix wrote with possible deletions:
> Hi,
>
>
> My input document looks like that :
>
> <a>
>     <b n="1">
>         <c>pea</c>
>         <d>apple</d>
>         <b n="2">
>             <c>kiwi</c>
>             <d>banana</d>
>         </b>
>     </b>
>     <b n="3">
>         <c>kiwi</c>
>         <d>banana</d>
>     </b>
> </a>
>
> The structure is recursive : b can contain b.
>
> I want to write a query to retrieve any b that contains "kiwi" and  
> "banana", but I want to exclude the first b (with n="1") because  
> the keywords are not in its own content (c+d), but in its b child's  
> content.
> The query should return b2 and b3.
>
> This query can't go :
>
> for $x in //b
> where $x[contains(., "kiwi") and contains(., "banana")]
> and not($x/c[contains(., "kiwi") and contains(., "banana")])
> return     $x
>
> because, sometimes my put could be :
>
> <a>
>     <b n="1">
>         <c>pea</c>
>         <d>apple</d>
>         <b n="2">
>             <c>kiwi</c>
>             <d>banana</d>
>         </b>
>         <e>kiwi banana</e>
>     </b>
>     <b n="3">
>         <c>kiwi</c>
>         <d>banana</d>
>     </b>
> </a>
>
> In that case, the query should return all three b.
>
> Thanks for your help,
>
> Billig
> _______________________________________________
> talk at x-query.com
> http://x-query.com/mailman/listinfo/talk

--
   | Prof. Dr. Torsten Grust                         grust at in.tum.de |
   |                                 http://www-db.in.tum.de/~grust/ |
   |     Database Systems - Technische Universität München (Germany) |