File: join_ellipse.sql

package info (click to toggle)
postgresql-q3c 2.0.1-4
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid, trixie
  • size: 5,548 kB
  • sloc: sql: 27,430; ansic: 3,908; python: 110; perl: 104; makefile: 101; sh: 17
file content (5 lines) | stat: -rw-r--r-- 508 bytes parent folder | download 
1
2
3
4
5
 
select count(*) from test1 as a, test as b where q3c_ellipse_join(a.ra,a.dec,b.ra,b.dec,0.002,1,0);
select count(*) from test1 as a, test as b where q3c_ellipse_join(a.ra,a.dec,b.ra,b.dec,0.004,1,0);
select count(*) from test1 as a, test as b where q3c_ellipse_join(a.ra,a.dec,b.ra,b.dec,0.0100115,1,0);
select count(*) from test1 as a, test as b where q3c_ellipse_join(a.ra,a.dec,b.ra,b.dec,0.0200015,1,0);
select count(*) from test1 as a, test as b where q3c_ellipse_join(a.ra,a.dec,b.ra,b.dec,0.042,1,0);