Bom Dia
Criei a seguinte tabela no postgresql com um campo xml
CREATE TABLE test_tablext
(
code_id character(8),
cardid character(1),
descr character varying(50),
percent numeric(10,2) DEFAULT 0,
days numeric(8,0) DEFAULT 0,
date_lim date,
"enable" boolean,
obs text,
"value" numeric(18,6) DEFAULT 0,
meuxml xml,
sr_recno numeric(15,0) NOT NULL DEFAULT
nextval('test_tablext_sq'::regclass),
sr_deleted character(1) NOT NULL DEFAULT ' '::bpchar,
CONSTRAINT test_tablext_sr_recno_key UNIQUE (sr_recno)
)
WITH (
OIDS=FALSE
);
e insiro dentro dele um xml com o seguinte comando
INSERT INTO "test_tablext" ( "code_id", "cardid", "descr", "percent",
"days", "date_lim", "enable", "obs", "value", "meuxml", "sr_deleted" )
VALUES ( '00001', NULL, '12/16/10 - 10:37:09', NULL, 999, '20101216',
true, 'This is a memo field. Seconds since midnight : 38229.77', NULL,
'<?xml version="1.0" encoding="utf-8"?><Array FatherId="-1" Id="0" Len="4"
Type="A"><Data Id="0" Pos="1" Type="N" Value="1"/><Data Id="0" Pos="2"
Type="N" Value="2"/><Data Id="0" Pos="3" Type="N" Value="3"/><Data Id="0"
Pos="4" Type="N" Value="4"/></Array>', ' ' )
quando verifico no banco, o campo comeca apenas no primeiro <Array
como faco para ele retornar o cabecalho <?xml version="1.0"
encoding="utf-8"?> junto com o xml?
[]s
Luiz
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
