Re: SQL challenge
From: Jan Hidders <jan.hidders_at_REMOVETHIS.pandora.be>
Date: Wed, 14 Jul 2004 15:36:03 GMT
Message-ID: <pan.2004.07.14.15.36.30.753507_at_REMOVETHIS.pandora.be>
>> > Is there an elegant SQL statement? If you say yes, then, I would
>> > think hard finding it:-)
>>
>> Yes, there is. We (some people in my research group) found it
>> ourselves, but we had to make the assumption that not all points are in
>> a single plane. Without that assumption things seem to get ugly.
>
> What data type are the coordinates of the points ?
Date: Wed, 14 Jul 2004 15:36:03 GMT
Message-ID: <pan.2004.07.14.15.36.30.753507_at_REMOVETHIS.pandora.be>
On Wed, 14 Jul 2004 08:26:26 +0300, x wrote:
> "Jan Hidders" <jan.hidders_at_REMOVETHIS.pandora.be> wrote in message > news:pan.2004.07.13.19.21.51.416635_at_REMOVETHIS.pandora.be...
>> > Is there an elegant SQL statement? If you say yes, then, I would
>> > think hard finding it:-)
>>
>> Yes, there is. We (some people in my research group) found it
>> ourselves, but we had to make the assumption that not all points are in
>> a single plane. Without that assumption things seem to get ugly.
>
> What data type are the coordinates of the points ?
Integers or floats. Doesn't really make much difference.
- Jan Hidders