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
put-callouts-in-sql-comments.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
