File: join_pm1.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 (11 lines) | stat: -rw-r--r-- 1,094 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
 
select count(*) from test_pm0 as a, test as b where q3c_join (a.ra,a.dec,b.ra,b.dec,0.002);
select count(*) from test_pm0 as a, test as b where q3c_join(a.ra,a.dec,b.ra,b.dec,0.004);
select count(*) from test_pm0 as a, test as b where q3c_join(a.ra,a.dec,b.ra,b.dec,0.01);
select count(*) from test_pm0 as a, test as b where q3c_join(a.ra,a.dec,b.ra,b.dec,0.02);
select count(*) from test_pm0 as a, test as b where q3c_join(a.ra,a.dec,b.ra,b.dec,0.042);

select count(*) from test_pm0 as a, test as b where q3c_join_pm (a.ra,a.dec,a.pmra,a.pmdec,1,a.epoch,b.ra,b.dec,2000,100,0.002);
select count(*) from test_pm0 as a, test as b where q3c_join_pm(a.ra,a.dec,a.pmra,a.pmdec,1,a.epoch,b.ra,b.dec,2000,100,0.004);
select count(*) from test_pm0 as a, test as b where q3c_join_pm(a.ra,a.dec,a.pmra,a.pmdec,1,a.epoch,b.ra,b.dec,2000,100,0.01);
select count(*) from test_pm0 as a, test as b where q3c_join_pm(a.ra,a.dec,a.pmra,a.pmdec,1,a.epoch,b.ra,b.dec,2000,100,0.02);
select count(*) from test_pm0 as a, test as b where q3c_join_pm(a.ra,a.dec,a.pmra,a.pmdec,1,a.epoch,b.ra,b.dec,2000,100,0.042);