MySQL Forums
Forum List  »  GIS

Re: GIS functions not available?
Posted by: Peter Bowyer
Date: August 31, 2007 04:22AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
8912
November 23, 2005 11:37AM
4487
December 07, 2005 11:03AM
4918
January 05, 2006 12:11PM
6365
June 11, 2007 10:23AM
Re: GIS functions not available?
5333
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.