On Wed, 2006-08-23 at 16:04 -0700, Frank Cohen wrote: > I'm doing a performance and scalability test project for a PostgreSQL > user who is working with geospatial data. The data is in GML form. > For instance: > > > <watch version="9" id="flight" time="2006-08-16T10:16:36.125-07:00"> > <point latitude="7" longitude="55"/> > <detail> > <gml:Point xmlns:gml="http://www.opengis.net/gml";> > <gml:coordinates>7.0,9.0</gml:coordinates> > </gml:Point> > </detail> > </watch> > > > I installed PostGIS and it supports Point and coordinates very well. > > I an not sure what I should do with the XML content using PostgreSQL? > For example, > > 1) Tom Dyson at http://www.throwingbeans.org/ > postgresql_and_xml_updated.html says "PostgreSQL 8 ships with > xpath_table to evaluate a set of XPath queries and returns the > results as a virtual table." > > These look like good XPath functions. Are they actually in PSQL > 8.1.4? I did not find them in the Windows installed version. If not, > are they recommended? Look at contrib/xml2. The function xpath_table is in that module. I'm not familiar enough with windows to tell you how to install it, but hopefully this gives you a good starting point. Regards, Jeff Davis
