Re: patches for items from TODO list - Mailing list pgsql-hackers

From Markus Bertheau
Subject Re: patches for items from TODO list
Date
Msg-id 1116377979.7656.5.camel@localhost.localdomain
Whole thread Raw
In response to Re: patches for items from TODO list  ("Sergey Ten" <sergey@sourcelabs.com>)
Responses Re: patches for items from TODO list
List pgsql-hackers
Dnia 13-05-2005, pią o godzinie 16:01 -0700, Sergey Ten napisał(a):

> <?xml version='1.0'?>
> <table>
>     <row>
>         <col name='col1' null='n'>Jackson, Sam</col>
>         <col name='col2' null='n'>\h</col>
>     </row>
>     <row>
>         <col name='col1' null='n'>It is "perfect".</col>
>         <col name='col2' null='n'>	</col>
>     </row>
>     <row>
>         <col name='col1' null='n'></col>
>         <col name='col2' null='y'></col>
>     </row>
> </table>

Why didn't you do something to the effect of

<?xml version='1.0'?>
<table><cols>    <col name='col1'/>    <col name='col2'/></cols><row>    <col null='n'>Jackson, Sam</col>    <col
null='n'>\h</col></row><row>   <col null='n'>It is "perfect".</col>    <col null='n'>	</col></row><row>
<col null='n'></col>    <col null='y'></col></row> 
</table>

This avoids repeating the column names in every row, which don't change
over the rows anyway. By reducing redundant information it also makes
structurally invalid XML less likely (whether that is relevant depends
on what people do with the XML data).

Also you could encode the XML output as UTF-8, which would make the
files more readable for humans if the text data is not ASCII.

Markus

--
Markus Bertheau <twanger@bluetwanger.de>

pgsql-hackers by date:

Previous
From: Neil Conway
Date:
Subject: Re: Learning curves and such (was Re: pgFoundry)
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Learning curves and such (was Re: pgFoundry)