Re: Decimal - Maximum is 30

2008-02-01 Thread Paul DuBois
At 9:50 PM -0600 1/31/08, Peter Brawley wrote: Postgres has PostGIS Oracle has OracleSpatial MySQL has ? OpenGis. As stated here: http://dev.mysql.com/doc/refman/5.0/en/gis-introduction.html -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL G

Re: Decimal - Maximum is 30

2008-01-31 Thread Peter Brawley
MySQL has ? Many Thanks for the link Martin-- - Original Message - From: "Michael Cole" <[EMAIL PROTECTED]> To: Sent: Thursday, January 31, 2008 8:45 PM Subject: Re: Decimal - Maximum is 30 On Friday 01 February 2008 7:32:33 am Warren Young wrote: The average grain

Re: Decimal - Maximum is 30

2008-01-31 Thread Warren Young
Michael Cole wrote: I think you missed something in your formula, You just have a 1 dimension dealt with here. That would be every grain in that line. Yes...so you use three columns to describe normal space. Call them x, y, and z. Or elevation, azimuth and range. Or... -- MySQL General

Re: Decimal - Maximum is 30

2008-01-31 Thread Martin Gainty
Cole" <[EMAIL PROTECTED]> To: Sent: Thursday, January 31, 2008 8:45 PM Subject: Re: Decimal - Maximum is 30 On Friday 01 February 2008 7:32:33 am Warren Young wrote: > The average grain of sand is a bit smaller than a millimeter. There are > a million millimeters per kilometer. &g

Re: Decimal - Maximum is 30

2008-01-31 Thread Michael Cole
On Friday 01 February 2008 7:32:33 am Warren Young wrote: > The average grain of sand is a bit smaller than a millimeter.  There are > a million millimeters per kilometer. > > 10^11 * 10^13 * 10^6 = 10^30 > > In other words, the current system is sufficient for establishing the > location of every

Re: Decimal - Maximum is 30

2008-01-31 Thread Warren Young
Eli Shemer wrote: Actually I'm not in liberty to reveal but it is essential to the project. In that case, I am awe-struck, even astounded, at the possibilities suggested by this hint. You must be working on a project that is literally astronomical in scope. Please, let me explain how I came

Re: Decimal - Maximum is 30

2008-01-31 Thread Michael Dykman
On Jan 31, 2008 2:56 PM, Eli Shemer <[EMAIL PROTECTED]> wrote: > Actually I'm not in liberty to reveal but it is essential to the project. > I will look for a workaround in code space when I find the time. > This first thing which springs to my mind is: what langauge are you using that can make us

RE: Decimal - Maximum is 30

2008-01-31 Thread Eli Shemer
cimal - Maximum is 30 Eli Shemer wrote: > > Is there any possible way to increase this limit ? I'm curious to know what it is you're doing where you need accuracy better than one part in a nonillion. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Decimal - Maximum is 30

2008-01-30 Thread Warren Young
Eli Shemer wrote: Is there any possible way to increase this limit ? I'm curious to know what it is you're doing where you need accuracy better than one part in a nonillion. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.c