On 09/19/2011 10:49 AM, Rob Sargent wrote:
Having a name space in the doc requires it's usage in the query.
yeah, I got it... I was using wrong one...
thanks.
On 09/17/2011 11:48 AM, boris wrote:
hi all,
I've inserted xml file :
http://www.w3.org/2001/XMLSchema-instance";>
zz
Thank you. It works perfect.
Dianna
Tim Landscheidt < t...@tim-landscheidt.de > wrote:
> If I understand the question correctly, try:
>
> | SELECT DISTINCT ON (consumer_id) consumer_id, move_date, history_timestamp
> |FROM (SELECT consumer_id, move_date, history_timestamp,
> |
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 :
>
>
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance";>
>
> zz
> ..
>
>
> to a table:
>
> CREATE TABLE "temp".tempxml
