SSDtests: query_spatialJoin.sql

File query_spatialJoin.sql, 163 bytes (added by jbecla, 9 years ago)
Line 
1SELECT count(*)
2FROM   X o1, X o2
3WHERE  ABS(o1.ra - o2.ra) < 0.00083 / o2.cosRadDecl
4  AND  ABS(o1.decl - o2.decl) < 0.00083 
5  AND  o1.objectId <> o2.objectId