Re: How to parse XML in Postgres newer versions also

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
Cc: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to parse XML in Postgres newer versions also
Date: 2019-03-17 14:19:33
Message-ID: B563F16528764890A998C435BF6FC93A@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

>You can use XMLTABLE function
>select xmltable.*
> from t,
> lateral
> xmltable(xmlnamespaces('urn:iso:std:iso:20022:tech:xsd:camt.053.001.02' as
> ns),
>
> '/ns:Document/ns:BkToCstmrStmt/ns:Stmt/ns:Ntry/.' passing t.x
> columns tasusumma numeric path 'ns:Amt')

In 9.1.5 this throws error

ERROR: syntax error at or near "("
LINE 20: lateral xmltable(xmlnamespaces(
^
SQL state: 42601
Character: 582

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Warner, Gary, Jr 2019-03-17 15:01:40 Re: Facing issue in using special characters
Previous Message Thomas Kellerer 2019-03-17 14:12:56 Re: How to parse XML in Postgres newer versions also