Having a name space in the doc requires it's usage in the query.
On 09/17/2011 11:48 AM, boris wrote: > 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. > > > > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql