Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
unique key & spatial column
That fuctions are implementation of OpenGIS for spatial data. I'm using it with MySQL 4.1.0-alfa. Check this: mysql> CREATE TABLE t1 (g POINT); mysql> INSERT t1 SET g=PointFromWKB(Point(1,1)); mysql> INSERT t1 SET g=PointFromWKB(Point(0,0)); mysql> INSERT t1 SET g=PointFromWKB(Point(1,0))... -
unique key & spatial column
I need unique (or primary) key with spatial (POINT) column. But when i try somthing like: mysql> create table m (g Point primary key); mysql> insert into m (g) values (PointFromText('point(1 1)')); mysql> insert into m (g) values (PointFromText('point(1 2)')); ERROR 1062: Duplicate entry '' for...
