I have tried to device some principles helpull in the inversion of
selection. We have seen recently several messages related to that subject
but with a scope limited to regions. I wanted something more general.
There is one basic requirement, that the table (MY_TAB) contains a column
(COLX) with unique object identifiers. If it does not have one, add a column
(COLX) and populate it with rowid.
Once the selection is done
select * from MY_TAB where NOT MY_TAB.COLX = ANY(select COLX from SELECTION)
With what I have seen and experimented with on the subject, it seems that
this a much more reliable and universal solution than any using geographic
operators (intersects, within...) which have some tendencies to
include/exclude adjacent objects and work only with closed objects.
I am open to any suggestion to improve on that.
Jacques Paris
e-mail alternate
[EMAIL PROTECTED] [EMAIL PROTECTED]
paris PC Consult (mainly MapInfo app.)
www.total.net/~rparis/gisproducts.htm
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
