RE: Spatial Extension in MySQL 4.1.1-alpha

2003-12-17 Thread Matt Lynch
lto:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 5:48 PM To: Steven Roussey; [EMAIL PROTECTED] Cc: 'Matt Lynch' Subject: Re: Spatial Extension in MySQL 4.1.1-alpha At 16:03 -0800 12/16/03, Steven Roussey wrote: >You did an insert this way: > > mysql> insert into geom va

Re: Spatial Extension in MySQL 4.1.1-alpha

2003-12-16 Thread Paul DuBois
At 16:03 -0800 12/16/03, Steven Roussey wrote: You did an insert this way: mysql> insert into geom values(GeomFromText('POINT(1,1)')); and expected results this way: mysql> select AsText(g) from geom; +---+ | AsText(g) | +---+ | Point(1 1)| +---+ 1 row in

Re: Spatial Extension in MySQL 4.1.1-alpha

2003-12-16 Thread Steven Roussey
You did an insert this way: mysql> insert into geom values(GeomFromText('POINT(1,1)')); and expected results this way: mysql> select AsText(g) from geom; +---+ | AsText(g) | +---+ | Point(1 1)| +---+ 1 row in set (0.00 sec) The formatting of the POINT coo

Spatial Extension in MySQL 4.1.1-alpha

2003-12-16 Thread Matt Lynch
Hi, I am trying out the new GIS capabilities in MySQL 4.1.1-alpha (windows) and I am trying to follow some of the examples from chapter 10 in the manual. Here is a snap shot of my run mysql> create table geom(g geometry); Query