On Wed, Jan 11, 2006 at 02:40:04PM -0700, Assad Jarrahian wrote: > I was running postgres 8.1 on a windows xp box and I recall > installing it with postgis option. > I had a method in a db there that called geodistance. Everything worked fine. Neither PostgreSQL nor PostGIS have a geodistance function, at least not in recent versions. However, PostGIS does have distance, distance_sphere, and distance_spheroid functions. > Now I tried to restore the db on the debian server thats running 8.1 > as well. The geodistance function (or any other geometry function ) is > not available. Googling for "geodistance" returns a few hundred hits, but googling for "postgresql geodistance" or "postgis geodistance" yields only a few hits. The following message to pgsql-hackers from over five years ago is the only hit I found in the PostgreSQL or PostGIS mailing lists: http://archives.postgresql.org/pgsql-hackers/2000-11/msg01232.php I'd guess geodistance is or was part of some add-on. If you connect to the XP box with psql, what does "\df+ geodistance" show? If it's an SQL or PL/pgSQL function then you could copy its source into the new database with CREATE FUNCTION, but maybe you'd be better off using one of the standard functions. What, if anything, does geodistance do that the standard PostGIS distance functions don't? -- Michael Fuhr
