ne 17. 3. 2019 v 15:19 odesílatel Andrus <kobruleht2@xxxxxx> napsal:
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
sure, XMLTABLE is supported from PostgreSQL 10.
Pavel
Andrus.
