Hi, I've looked at some of the tests for the XML support but I am still confused if this is possible or not. Given a table created with an xml column:
create table xmlTab (id integer, xml_col xml); Containing these two xml documents: <Contact> <id>1</id> <firstname>Susan</firstname> <lastname>Cline</lastname> </Contact> <Contact> <id>2</id> <firstname>Apache</firstname> <lastname>User</lastname> </Contact> I'd like to come up with a query that returns results ordered by firstname (or any other element in the XML document.) So, in this example the document with the id of "2" would appear in the result of the select before the document with the id of "1". If this query is possible, can someone please post an example? The other question I have is which other supporting jar files I need to issue this query? I think I need the following (but can someone confirm if specific versions are required?): xml-apis.jar xercesImpl.jar xalan.jar Thanks, Susan
