Re: XML schemas and PG column names

Andrew Dunstan <andrew@dunslane.net> writes:
> Tom Lane wrote:
>> 2. What happens when the column name contains characters that would have
>> to be escaped, such as "<" --- haven't you just replaced one de-escaping
>> problem with another?

> But the difference is that the XML processor will automatically unescape 
> this value (and re-escape it on output if necessary). The user won't 
> have to do anything (or shouldn't if their XML processor is worth 
> anything at all).

OK, so your argument is that this is a standard escaping rule and the
one in the SQL standard is, um, not standard.  I wonder why the SQL
committee felt compelled to invent their own, then?
        regards, tom lane