Re: Disable fontification when exporting tables

[Amos Bird <amosbird@gmail.com>]

[-- Attachment #1: Type: text/plain, Size: 2509 bytes --]

#+OPTIONS: latex:t toc:nil H:3

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

[-- Attachment #2.1: Type: text/html, Size: 2954 bytes --]