hi all,
I've inserted xml file :
<?xml version="1.0"?>
<document xmlns:s1="urn:myorg/s1" xmlns="urn:myorg"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<id num="111-222-333-4444"/>
<title>zzzzzz</title>
......................
to a table:
CREATE TABLE "temp".tempxml
(
record xml
)
I can get it using:
select * from temp.tempxml
but, I can't get any values using xpath. ex:
select (xpath('/document/title/text()', record ))[1] from temp.tempxml
am I doing it right?
thanks.