#+OPTIONS: latex:t toc:nil H:3 Thanks!
Nicolas Goaziou <m...@nicolasgoaziou.fr> writes: > Amos Bird <amosb...@gmail.com> writes: > >> | QueryID | SQL Text >> >> | Query Time (Seconds) | Query Time Hot (Seconds) | >> |---------+-----------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+--------------------------| >> | Q0 | SELECT avg(c1) from (select Year, Month, count(*) as c1 from >> ontime group by Year, Month); >> | 1.27 | 0.13 | >> | Q1 | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE Year >= 2000 >> AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC; >> | 1.23 | 0.21 | >> | Q2 | SELECT DayOfWeek, count(*) AS c FROM ontime WHERE DepDelay>10 >> AND Year >= 2000 AND Year <= 2008 GROUP BY DayOfWeek ORDER BY c DESC; >> | 1.4 | 0.25 | >> | Q3 | SELECT Origin, count(*) AS c FROM ontime WHERE DepDelay>10 AND >> Year >= 2000 AND Year <= 2008 GROUP BY Origin ORDER BY c DESC LIMIT 10; >> | 5.2 | 0.29 | >> | Q4 | SELECT Carrier, count(*) FROM ontime WHERE DepDelay>10 AND Year >> = 2007 GROUP BY Carrier ORDER BY count(*) DESC; >> | 1.0 | 0.09 | >> | Q5 | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime >> WHERE Year = 2007 GROUP BY Carrier ORDER BY Carrier; >> | 0.12 | 0.04 | >> | Q6 | SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime >> WHERE Year >= 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier; >> | 0.42 | 0.26 | >> >> that is, it contains = characters which breaks the verbatim markup. > > Then use `code' markup: > > ~SELECT Carrier, avg(DepDelay > 10) * 1000 AS c3 FROM ontime WHERE Year >= > 2000 AND Year <= 2008 GROUP BY Carrier ORDER BY Carrier;~ > > which is more appropriate than `verbatim' for SQL code anyway. > >> Is there a way to specify the whole column to be verbatim? > > No, there isn't. > > Regards, -- Amos Bird amosb...@gmail.com
