File: join_pm1.sql

package info (click to toggle)
postgresql-q3c 1.6.0-1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 2,892 kB
  • sloc: sql: 13,151; ansic: 3,741; python: 110; perl: 104; makefile: 89; sh: 3
file content (11 lines) | stat: -rw-r--r-- 1,084 bytes parent folder | download 
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,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,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,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,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,a.epoch,b.ra,b.dec,2000,100,0.042);