Hi Colleagues, once more!
On Wed, 2008-05-14 at 18:07 +0100, Jeff Lusted wrote:
> -- Find all observed objects within 0.001 degrees of those
> -- observed objects which have a quality greater than 3
> -- and a redshift greater than 1.6
> select s.obsra, s.obsdec, s.z, s.specid, s.targetname, s.quality from
> spectra as s
> where s.quality > 3 and s.z > 1.6 and
> CONTAINS( POINT( 'J2000', s.ra, s.dec ), CIRCLE( 'J2000', s.ra, s.dec,
> 0.001 ) ) = 1 ;
OK, my apologies, this is wrong. I think it needs some form of correlated query to work. I'll see what I can come up with, unless someone else can step in? But you can see what I'm getting at. So the question about STC-s still stands.
Regards
Jef
-- Jeff Lusted tel: +44 (0)116 252 3581 Astrogrid Project mob: +44 (0)7973 492290 Dept Physics & Astronomy email: jl99-at-star.le.ac.uk University of Leicester web: http://www.astrogrid.orgReceived on 2008-05-14Z19:17:36