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
9573
November 23, 2005 11:37AM
4722
December 07, 2005 11:03AM
5149
January 05, 2006 12:11PM
6678
June 11, 2007 10:23AM
Re: GIS functions not available?
5592
August 31, 2007 04:22AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.