Thanks for replying.
It was a typo ...
Also id fom example should be objid ...
Anyway, without the typo, the result set is empty.
There is also a weird thing:
SELECT
xpath_nodeset(rawdata, '/mydocument/body/chapter/contents/paragraph')
FROM xmldocuments
will output
xpath_nodeset
----------------
(empty line)
(empty line)
(empty line)
(empty line)
4 record(s) selected [Fetch MetaData: 0/ms] [Fetch Data: 1/ms]
[Executed: 8/7/06 5:42:54 PM CEST ] [Execution: 3/ms]
- (empty line) is what I wrote to say that there was nothing on output -
which makes me think there is something wrong with XPath implementation.
Anyway, is there a solution to my problems?
Marian
Csaba Nagy wrote:
> [snip]
>> <paragraph id="01"
>> style="para01"></paragraph>
> ^^^^
> [snip]
>>
xpath_bool(rawdata,'/mydocument/body/chapter/contents/paragraph[objid="2_1"]');
> ^^^^^
> To me it looks like attribute name mismatch, not to mention you forgot
> the '@' (i.e. I guess you wanted the xpath:
> '/mydocument/body/chapter/contents/[EMAIL PROTECTED]"2_1"]'
>
> If you were just sloppy writing the email, maybe you should also check
> your actual code for such sloppiness ;-)
>
> Cheers,
> Csaba.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
