Me and Teodor hope to work on contrib/ltree to add support for sort of xml. Any ideas are welcome !
Regards, Oleg On Fri, 29 Nov 2002, Christopher Kings-Lynne wrote: > 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]) > Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: [EMAIL PROTECTED], http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly