[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,
- [O] Disable fontification when exporting tables, Amos Bird, 2017/09/27
- Re: [O] Disable fontification when exporting tables, Nicolas Goaziou, 2017/09/28
- Re: [O] Disable fontification when exporting tables, Amos Bird, 2017/09/28
- Re: [O] Disable fontification when exporting tables, Nicolas Goaziou, 2017/09/29
- Re: [O] Disable fontification when exporting tables, Amos Bird, 2017/09/29
- Re: [O] Disable fontification when exporting tables, Nicolas Goaziou, 2017/09/30
- Re: [O] Disable fontification when exporting tables, Amos Bird, 2017/09/30
- Re: [O] Disable fontification when exporting tables,
Nicolas Goaziou <=
- Re: [O] Disable fontification when exporting tables, Amos Bird, 2017/09/30