Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 00065B5DC02
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 19 Sep 2011 11:49:31 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 77843-07 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Mon, 19 Sep 2011 14:49:25 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.8.0-rc2
Received: from out02.mta.xmission.com (out02.mta.xmission.com [166.70.13.232])
	by mail.postgresql.org (Postfix) with ESMTP id 4BC8CB5DC01
	for <pgsql-sql@postgresql.org>; Mon, 19 Sep 2011 11:49:25 -0300 (ADT)
Received: from in01.mta.xmission.com ([166.70.13.51])
	by out02.mta.xmission.com with esmtps (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1R5f9w-00022o-9F; Mon, 19 Sep 2011 08:49:24 -0600
Received: from [208.187.158.94] (helo=[172.16.1.26])
	by in01.mta.xmission.com with esmtpsa (TLSv1:AES256-SHA:256)
	(Exim 4.69) (envelope-from <robjsargent@gmail.com>)
	id 1R5f9v-0007H5-Qi; Mon, 19 Sep 2011 08:49:24 -0600
Message-ID: <4E775670.9090208@gmail.com>
Date: Mon, 19 Sep 2011 08:49:20 -0600
From: Rob Sargent <robjsargent@gmail.com>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.18) Gecko/20110616 SUSE/3.1.11 Lightning/1.0b2
	Thunderbird/3.1.11
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
References: <j52me3$ehq$1@speranza.aioe.org>
In-Reply-To: <j52me3$ehq$1@speranza.aioe.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-XM-SPF: eid=; ; ; mid=; ; ; hst=in01.mta.xmission.com; ; ;
 ip=208.187.158.94;
	; ; frm=robjsargent@gmail.com; ; ; spf=neutral
X-XM-AID: U2FsdGVkX18ZJNardmN7b3UW0vEo3FZRapEBpTLjy7M=
X-SA-Exim-Connect-IP: 208.187.158.94
X-SA-Exim-Mail-From: robjsargent@gmail.com
X-Spam-DCC: XMission; sa03 1397; Body=1 Fuz1=1 Fuz2=1 
X-Spam-Combo: ;pgsql-sql@postgresql.org
X-Spam-Relay-Country: 
Subject: Re: select xpath ...
X-SA-Exim-Version: 4.2.1 (built Fri, 06 Aug 2010 16:31:04 -0600)
X-SA-Exim-Scanned: Yes (on in01.mta.xmission.com)
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.889 tagged_above=-5 required=5 tests=BAYES_00=-1.9,
	FREEMAIL_FROM=0.001, T_TO_NO_BRKTS_FREEMAIL=0.01
X-Spam-Level: 
X-Archive-Number: 201109/51
X-Sequence-Number: 35851

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.
>
>
>
>