There's an inbuilt function for that:
select p.ra,p.dec,p.b,p.l,p.objID,p.run,p.rerun,p.camcol,p.field,p.obj,p.type,p.flags,p.fiberMag_r,p.petroMag_u,p.petroMag_g,p.petroMag_r,p.petroMag_i,p.petroMag_z,
p.petroRad_r,p.petroR50_r,p.petroR90_r,p.isoA_g,p.isoB_g,p.isoA_r,p.isoB_r,p.isoPhi_r,p.specObjID into mydb.MiceB from PhotoObjAll as p,
dbo.fGetNearbyObjEq(191.5, 30.7, 1.0) n
WHERE p.objID = n.objID
and
( flags & (dbo.fPhotoFlags('NOPETRO') +
dbo.fPhotoFlags('MANYPETRO')
+dbo.fPhotoFlags('TOO_FEW_GOOD_DETECTIONS')) ) = 0
No comments:
Post a Comment