Hi,
FOR XML AUTO
I wanted to modify the sql grammar
so it would be processed automatically. How feasible is it to do
this?
I don't know. I'm not sure how complex the solution would be, and I'm
not sure how useful it would be. To me, it looks like it would add
quite a lot of complexity to the parser. I'm not sure if it's a good
idea to add such features into the database engine itself - wouldn't
it make more sense to use a solution that is database independent, so
it can be used for other databases as well? FOR XML seems to be
available in MS SQL Server only.
H2 supports XML features that are much less invasive to the database
engine itself:
http://h2database.com/html/functions.html#xmlattr
http://h2database.com/html/functions.html#xmlnode
http://h2database.com/html/functions.html#xmlcomment
http://h2database.com/html/functions.html#xmlcdata
http://h2database.com/html/functions.html#xmlstartdoc
http://h2database.com/html/functions.html#xmltext
Those are simple text functions. They can be ported to any database
(including MS SQL Server). They don't require any change in the
database engine or parser, or any special data type. An example on how
to use those functions is:
http://code.google.com/p/h2database/source/browse/trunk/h2/src/test/org/h2/samples/newsfeed.sql
This will give you full control over the generated XML (you could even
generate HTML if required).
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups H2
Database group.
To post to this group, send email to h2-database@googlegroups.com.
To unsubscribe from this group, send email to
h2-database+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.