Print

---

Hi there,

I was looking at the pipeQA queries in the test case, and was wondering 
if someone could help explain this one:
SELECT sce.filterName, sce.field, sce.camcol, sce.run
FROM   Science_Ccd_Exposure AS sce
WHERE  (sce.filterName like '%')
    AND (sce.field = 536)
    AND (sce.camcol like '%')
    AND (sce.run = 94);

I think the sce.filterName like '%' and sce.camcol like '%' clauses are 
nearly useless.
But maybe someone wanted sce.filterName is not null and sce.camcol is 
not null (I don't know why... I didn't see any rows in the table where 
either was null).

-Daniel

########################################################################
Use REPLY-ALL to reply to list

To unsubscribe from the QSERV-L list, click the following link:
https://listserv.slac.stanford.edu/cgi-bin/wa?SUBED1=QSERV-L&A=1