I am using query_to_xml with nulls set to false in postgresql 9.0.4. (I believe the behavior was also present in 8.4.)
The documentation for query_to_xml says that if set to true, nulls with be treated with xsi:nil="true" and "An appropriate namespace declaration will be added to the result value. If false, columns containing null values are simply omitted from the output."
This suggests to me that if set to false, there should be no added namespace declaration, but, in practice, the xsi namespace is present.
Is this the designed, intentional behavior or accidental?
Lynn Dobbs
Chief Technical Officer
CreditLink Corporation
858 496 1010 x 103 |