From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: Disable fontification when exporting tables Date: Sat, 30 Sep 2017 09:49:13 +0200 Message-ID: <87a81clj7q.fsf@nicolasgoaziou.fr> References: <8737785ytb.fsf@gmail.com> <874lrmodvo.fsf@nicolasgoaziou.fr> <87bmlus1ci.fsf@gmail.com> <878tgxmh1q.fsf@nicolasgoaziou.fr> <87a81drnsv.fsf@gmail.com> <87ing0ljso.fsf@nicolasgoaziou.fr> <877ewgskar.fsf@gmail.com> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:35414) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dyCWU-00071O-2U for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:49:18 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dyCWT-0006Le-8C for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:49:18 -0400 Received: from relay2-d.mail.gandi.net ([2001:4b98:c:538::194]:55999) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1dyCWT-0006LL-1h for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:49:17 -0400 In-Reply-To: <877ewgskar.fsf@gmail.com> (Amos Bird's message of "Sat, 30 Sep 2017 15:43:56 +0800") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: Amos Bird Cc: "emacs-orgmode@gnu.org" Amos Bird 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,