I cannot use simply mask=ANYINTERACT because, TOUCH is allowed. While selecting postal code polygon adjacent postal codes TOUCH. Ideally geometry of postal codes TOUCH? Am not sure about this.
You could use MINUS to subtract the count where mask=touch from the count where mask=anyinteract.
1 person found this helpful
Can I use multiple masks as mentioned in below query?
Yes you can use multiple masks in a single query as you have done. Just list all the possible masks other than TOUCH and it should work find.
Have you tried it? Did it work as expected?
Yes it worked with multiple masks. Was wondering if there would be any performance issue as mentioned in oracle documentation. I am not using UNION ALL here.