Re: Sessions at Trieste

Hi colleagues!

On Wed, 2008-05-14 at 18:17 +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 ;

This was clearly wrong. I've scratched my head a bit more for queries where circle is dynamic and possibly could not be expressed in one query using STC-s. Are these two any better? I'm trying hard here. They compile according to the latest parser, so obey the specification syntactically:

• Find those observed objects which are within a radius
• of 0.001 degrees of the observed object with
• the highest good quality redshift... SELECT s.obsra, s.obsdec, s.z, s.specid, s.targetname, t.obsra, t.obsdec, t.z, t.specid, t.targetname FROM spectra as s, spectra as t WHERE s.z in ( SELECT MAX(b.z) FROM spectra as b WHERE b.quality >= 3 ) AND CONTAINS( POINT( 'J2000', t.obsra, t.obsdec, ), CIRCLE( 'J2000', s.obsra, s.obsdec, 0.001 ) ) = 1 ;
• 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, t.obsra, t.obsdec, t.z, t.specid, t.targetname FROM spectra as s, spectra as t WHERE s.z in ( SELECT b.z FROM spectra as b WHERE b.z > 1.6 and b.quality > 3 ) AND CONTAINS( POINT( 'J2000', t.ra, t.dec ), CIRCLE( 'J2000', s.ra, s.dec, 0.001 ) ) = 1 ;

Phew! I hope you don't think I'm stupid! Regards
Jeff

-- 
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.org