Print

Print


Daniel,

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

	Yes, but they allow the same query template to be used in a
variety of situations, limiting to a specific filter or not.  These are
machine-generated queries, not human-written ones.

-- 
Kian-Tat Lim, LSST Data Management, [log in to unmask]

########################################################################
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