File: join_pm1.sql

package info (click to toggle)
postgresql-q3c 2.0.0-7
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 5,340 kB
  • sloc: sql: 26,253; ansic: 3,924; python: 110; perl: 104; makefile: 85; sh: 3
file content (11 lines) | stat: -rw-r--r-- 1,094 bytes parent folder | download | duplicates (4) 
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);