From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Andrus <kobruleht2(at)hot(dot)ee> |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: How to parse XML in Postgres newer versions also |
Date: | 2019-03-17 15:59:44 |
Message-ID: | CAFj8pRCKnT_hiHeS268e5SNryY0dDUFaBDe9qvMBLT5TBqC2Wg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
ne 17. 3. 2019 v 15:11 odesílatel Andrus <kobruleht2(at)hot(dot)ee> napsal:
> Hi
>
> >This variant is working
> >postgres=# SELECT
> > (xpath('/ns:Ntry/ns:Amt/text()', x,nsa))[1]::text::numeric AS
> tasusumma
> > FROM (
> > SELECT
> unnest(xpath('/ns:Document/ns:BkToCstmrStmt/ns:Stmt/ns:Ntry',
> >x,nsa)) as x,
> > nsa
> > FROM t
> > ) Ntry
> >;
> >But I have not a idea, why old code doesn't work. It is little bit
> strange so it worked without namespace before Amt tag.
> In 9.1.5 it returns nulls
>
> In 9.1.5 without namespaces
>
> (xpath('Amt/text()', x,nsa))[1]::text::numeric AS tasusumma
>
> works.
>
> How to make it work in both versions?
> Is it possible add some CASE WHEN or IF command or any other idea ?
>
Probably this bugfix breaks your code
9.1 is unsupported release, so if you can, just fix it for supported
releases.
else where, you need to prepare two different expressions.
Regards
Pavel
>
> Andrus.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2019-03-17 16:37:43 | Re: How to parse XML in Postgres newer versions also |
Previous Message | Pavel Stehule | 2019-03-17 15:38:41 | Re: How to parse XML in Postgres newer versions also |