emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [O] Disable fontification when exporting tables


From: Nicolas Goaziou
Subject: Re: [O] Disable fontification when exporting tables
Date: Sat, 30 Sep 2017 09:49:13 +0200
User-agent: Gnus/5.13 (Gnus v5.13) Emacs/25.2 (gnu/linux)

Amos Bird <address@hidden> 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,



reply via email to

[Prev in Thread] Current Thread [Next in Thread]