BUG #5859: XML result in line and column

Поиск
Список
Период
Сортировка
От Alexandre
Тема BUG #5859: XML result in line and column
Дата
Msg-id 201102011520.p11FKpLt022295@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5859: XML result in line and column  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: BUG #5859: XML result in line and column  (Mike Fowler <mike@mlfowler.com>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5859
Logged by:          Alexandre
Email address:      ultrago@gmail.com
PostgreSQL version: 8.4.7
Operating system:   Windows 7
Description:        XML result in line and column
Details:

The name of the xml tag is not being updated, becoming the first name
registry for all. Here is example:

Create table AUDITORIA_ANTERIOR
(
    SEQUENCIA Serial NOT NULL,
    SEQUENCIA_AUDITORIA Integer NOT NULL,
    REGISTRO Text NOT NULL,
primary key (SEQUENCIA,SEQUENCIA_AUDITORIA)
);

insert into auditoria_anterior (sequencia_auditoria, registro)
values (1, '<?xml version="1.0" encoding="iso-8859-1"?><ROOT>
<CLIENTES><CGC_CPF_CLIENTE>12345678901</CGC_CPF_CLIENTE><TIPO>1</TIPO><CODIG
O_CONVENIO></CODIGO_CONVENIO><PESSOA>F</PESSOA><NOME>JOAO DA
SILVA</NOME></CLIENTES> </ROOT>')

SELECT * FROM
xpath_table('sequencia',
            'registro',
            'auditoria_anterior',
            'name(/ROOT/CLIENTES/*)|/ROOT/CLIENTES/*',
            'sequencia = 1')
AS t(sequencia integer, coluna text, valor text)

--Incorrect result-----------------------------------
sequencia   coluna            valor
integer     text              text
--------------------------------------------------
1           CGC_CPF_CLIENTE   12345678901
1           CGC_CPF_CLIENTE   1
1           CGC_CPF_CLIENTE   F
1           CGC_CPF_CLIENTE   JOAO DA SILVA


--Result that would be right to be presented----------
sequencia   coluna            valor
integer     text              text
--------------------------------------------------
1           CGC_CPF_CLIENTE   12345678901
1           TIPO              1
1           PESSOA            F
1           NOME              JOAO DA SILVA

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Feature request: include script file into function body
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump doesn't save altered column information for inherited columns