Changeset 18609 for trunk/ippTools/share/stacktool_definebyquery_part1.sql

Timestamp:

Jul 17, 2008, 4:12:41 PM (18 years ago)

Author:

Paul Price

Message:

That ORDER BY which I claimed was so important wasn't really. I think I was in shaky ground so far as standard SQL is concerned (undefined behaviour). By explicitly taking the MAX, I don't need to ORDER BY and then hope that it chooses the right one. Besides, MAX is faster than ORDER BY.

File:

• trunk/ippTools/share/stacktool_definebyquery_part1.sql (modified) (1 diff)

trunk/ippTools/share/stacktool_definebyquery_part1.sql

@@ -4 +4 @@
 
 SELECT
-    *
+    skycell_id,
+    tess_id,
+    filter,
+    num_warp,
+    MAX(num_stack) AS num_stack
 FROM ((
     -- Number of stack-ready warps as a function of skycell and filter