[HACKERS] Unhelpful typesetting of callouts in example queries in the docs

Поиск
Список
Период
Сортировка
От Thomas Munro
Тема [HACKERS] Unhelpful typesetting of callouts in example queries in the docs
Дата
Msg-id CAEepm=268=4CJ0bRdkHH-aQ4pwhv4isMnRaGLPo62T=JR8nVYA@mail.gmail.com
обсуждение исходный текст
Ответы Re: [HACKERS] Unhelpful typesetting of callouts in example queries inthe docs  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
Hi

A novice user asked me about the last example here, which kept producing errors:

https://www.postgresql.org/docs/9.6/static/tutorial-agg.html?

It turned out that the 'callout' was causing confusion because it
sticks "(1)" into the middle of the query in approximately the same
typeface:

SELECT city, max(temp_lo)
    FROM weather
    WHERE city LIKE 'S%'(1)
    GROUP BY city
    HAVING max(temp_lo) < 40;

Maybe we should move it over a bit (?) and make it a comment, in case
it gets copied-and-pasted or otherwise misinterpreted?

SELECT city, max(temp_lo)
    FROM weather
    WHERE city LIKE 'S%'           -- (1)
    GROUP BY city
    HAVING max(temp_lo) < 40;

See attached which does that and there and a couple of other places.

-- 
Thomas Munro
http://www.enterprisedb.com

-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Steele
Дата:
Сообщение: [HACKERS] Final commitfest for 10.0 almost underway
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] bytea_output output of base64