Re: GIS functions not available?
I'm getting exactly the same error message
mysql> SELECT *, Distance(position, PointFromText('POINT(-1.393054, 50.930227)')) FROM geospatial;
ERROR 1305 (42000): FUNCTION scn.Distance does not exist
This is with MySQL 5.0.44 on Gentoo. I couldn't see any compile flag to enable the spatial extensions, so I believe they're built into MySQL by default?
Any help much appreciated.
Peter
Subject
Views
Written By
Posted
9722
November 23, 2005 11:37AM
4803
December 07, 2005 11:03AM
5226
January 05, 2006 12:11PM
6813
June 11, 2007 10:23AM
Re: GIS functions not available?
5713
August 31, 2007 04:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.