Re: [postgis-users] AsGML and AsKML not working in 1.3.2?

2008-03-17 Thread David Jordan
If I try that I get ERROR: 42883: function st_asgml(geometry) does not exist Paul Ramsey <[EMAIL PROTECTED]> wrote: Try ST_AsGML and ST_AsKML P On 3/17/08, davidj2k wrote: > > I am trying to use the AsGML and AsKML functions in PostGIS 1.3.2 I get this > error when trying to use AsGML > > "E

Re: [postgis-users] AsGML and AsKML not working in 1.3.2?

2008-03-17 Thread David Jordan
Ramsey <[EMAIL PROTECTED]> wrote: select postgis_full_version(). I am seeing it work just fine on my installation... pramsey=# select st_asgml(test_geom) from test; On 3/17/08, David Jordan wrote: > If I try that I get > ERROR: 42883: function st_asgml(geometry) does not exist >

Re: [postgis-users] AsGML and AsKML not working in 1.3.2?

2008-03-18 Thread David Jordan
That did the trick, thank you again Paul Ramsey <[EMAIL PROTECTED]> wrote: Run lwpostgis_upgrade.sql on your old database, that should refresh the function signatures to match the underlying .so. P On 3/17/08, David Jordan wrote: > I think I might know what the problem is, I a

Re: [postgis-users] Distance function is not in meters

2008-03-18 Thread David Jordan
If I use sphere they have to both be points, the actual search I am doing is distance(the_geom, GeometryFromText('POINT(10 10)',4326)) the_geom field is a polygon or a multipolygon Paul Ramsey <[EMAIL PROTECTED]> wrote: distance_sphere(GeometryFromText('POINT(10 10)',4326), GeometryFrom