Wow Hannu - your list puts mine to shame! > "Application server support" > ---------------------------- > * better XML integration > > - XML(*) aggregate function returning XML representation of subquery > > - XML input/output to/from tables > > - XML searchable/indexable in fields)
I've had thoughts about XML too. Since XML is hierachical, imagine being able to index xml using contrib/ltree or something! ie. We create a new 'xml' column type. We create a new indexing scheme for it based on ltree & gist. You index the xml column. Then you can do sort of XPath queries: SELECT * FROM requests WHERE xml_xpath('/request/owner/name', datafield) = 'Bob'; And it would be indexed. Imaging being able to pull up all XML documents that had certain properties, etc. MS-SQL has a SELECT ... FOR XML clause, but we could always just create function called xml_select() or something now that we can return recordsets. Chris ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])