Update of /cvsroot/monetdb/sql/src/test/XML/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv11413/XML/Tests
Modified Files:
xml.sql
Log Message:
approved output after changing to the storage layer.
Its mostly changed output order. Also removed some bat leaks in the process.
Index: xml.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/XML/Tests/xml.sql,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- xml.sql 1 Sep 2007 12:27:41 -0000 1.1
+++ xml.sql 5 Sep 2007 08:27:25 -0000 1.2
@@ -28,3 +28,16 @@
from Customers c, Projects p
where c.CustId = p.CustId
order by c.CustId;
+
+
+select
+ xmlelement(name "Customer",
+ xmlattributes(c.CustId as "id"),
+ xmlforest(c.Name as "name", c.City as city),
+ xmlelement(name projects,
+ (select xmlagg(xmlelement(name project,
+ xmlattributes(p.ProjId as "id"),
+ xmlforest(p.Name as name)))
+ from Projects p
+ where p.CustId = c.CustId) )) as "customer_projects"
+from Customers c;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
