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
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.