Re: [SQL] nesting XmlAgg

2008-07-03 Thread Peter Eisentraut
Am Donnerstag, 3. Juli 2008 schrieb Isaac Dover: select   XmlElement(name Catalog,     XmlElement(name Tables,       XmlAgg(XmlElement(name Table, XmlAttributes(T.table_name as Name), XmlElement(name Columns, -- i was attempting to aggregate here as well         (select XmlElement(name

[SQL] nesting XmlAgg

2008-07-02 Thread Isaac Dover
hi all, i'm coming from the MS SQLXML world and attempting to learn SQL/XML, but i'm having some trouble... my first project, which i thought would be simple, is to create an xml model using the information schema views... i'm simply trying to build a document such as: Catalog Name=SomeCatalog