[postgis-devel] EMPTY

Chris Hodgson chodgson at refractions.net
Tue Oct 6 12:45:39 PDT 2009


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
>   




More information about the postgis-devel mailing list