Update of /cvsroot/monetdb/sql/src/test/XML/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv12834/src/test/XML/Tests
Modified Files:
Tag: GDK-2
xml.sql
Log Message:
propagated changes of Monday Sep 03 2007 - Thursday Sep 06 2007
from the development trunk to the GDK-2 branch
Index: xml.sql
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/XML/Tests/xml.sql,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- xml.sql 3 Sep 2007 13:12:07 -0000 1.1.2.2
+++ xml.sql 6 Sep 2007 13:52:11 -0000 1.1.2.3
@@ -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
