[postgis-devel] EMPTY

Paul Ramsey pramsey at cleverelephant.ca
Tue Oct 6 13:34:45 PDT 2009


I'm going to change my intersection/disjoint answers to agree w/ SQL
Server. They are not bad, and they maintain the symmetry between where
intersection => ! disjoint.

P.

On Tue, Oct 6, 2009 at 12:45 PM, Chris Hodgson <chodgson at refractions.net> wrote:
> I moved these and summarized the interesting results from SQL Server 2008
> next to your original lines Paul.
>
> Note that SQL Server says that everything is disjoint from empty, including
> empty itself - whereas your original guesses were to return false.
>
> So far I think I like SQL Server's answers. Would be good to compare with
> oracle spatial too.
>
> Chris
>
> Paul Ramsey wrote:
>>
>> Regina, could you move your SQL Server examples down to a big block at
>> the end, so the main part of the document is more readable? So far I
>> agree with SQL Server in all the examples! Those guys are smart! :)
>>
>> P
>>
>> On Tue, Oct 6, 2009 at 12:12 PM, Paul Ramsey <pramsey at cleverelephant.ca>
>> wrote:
>>
>>>
>>> On Tue, Oct 6, 2009 at 12:03 PM, Chris Hodgson <chodgson at refractions.net>
>>> wrote:
>>>
>>>
>>>>
>>>> I would dare say that geometry empty is more like zero, than null.
>>>>
>>>
>>> Bingo, there's a useful mental model. Wikify that!
>>>
>>>
>>
>> _______________________________________________
>> postgis-devel mailing list
>> postgis-devel at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>>
>
> _______________________________________________
> postgis-devel mailing list
> postgis-devel at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-devel
>



More information about the postgis-devel mailing list