From mboxrd@z Thu Jan 1 00:00:00 1970 From: Amos Bird Subject: Re: Disable fontification when exporting tables Date: Sat, 30 Sep 2017 15:56:37 +0800 Message-ID: <8760c0sjpm.fsf@gmail.com> 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> <87a81clj7q.fsf@nicolasgoaziou.fr> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=-=-=" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:36645) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dyCdh-0000Tz-3C for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:56:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dyCde-0003Gk-Ac for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:56:45 -0400 Received: from mail-pf0-x22b.google.com ([2607:f8b0:400e:c00::22b]:57204) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1dyCde-0003GK-1B for emacs-orgmode@gnu.org; Sat, 30 Sep 2017 03:56:42 -0400 Received: by mail-pf0-x22b.google.com with SMTP id g65so837808pfe.13 for ; Sat, 30 Sep 2017 00:56:41 -0700 (PDT) In-reply-to: <87a81clj7q.fsf@nicolasgoaziou.fr> 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: Nicolas Goaziou Cc: "emacs-orgmode@gnu.org" --=-=-= Content-Type: text/plain #+OPTIONS: latex:t toc:nil H:3 Thanks! Nicolas Goaziou writes: > 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, -- Amos Bird amosbird@gmail.com --=-=-= Content-Type: multipart/related; boundary="==-=-=" --==-=-= Content-Type: text/html

Thanks!

Nicolas Goaziou <mail@nicolasgoaziou.fr> writes:

> Amos Bird <amosbird@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
amosbird@gmail.com

--==-=-=-- --=-=-=--