From: Oli Sennhauser <oli.sennhauser@fromdual.com>
To: pgsql-docs@lists.postgresql.org
Subject: Little formatting issues in doc
Date: Tue, 29 Sep 2026 11:20:06 +0200
Message-ID: <777637c4-9d31-498d-a8ef-645fb510bf5a@fromdual.com> (raw)
Hello all
Working with anonymous blocks I recently found a formatting issue which
confused me at the first look:
DO $$DECLARE r record;
BEGIN
Source:
https://www.postgresql.org/docs/current/sql-do.html#SQL-DO-EXAMPLES and
~/src/postgresql/doc/src/sgml/ref/do.sgml
Suggested improvement:
DO $$
DECLARE
r record;
BEGIN
Shall I write a patch for this? Anybody willing to look at a patch?
<programlisting>
DO $$
DECLARE
r record;
BEGIN
FOR r IN SELECT table_schema, table_name FROM information_schema.tables
WHERE table_type = 'VIEW' AND table_schema = 'public'
LOOP
EXECUTE 'GRANT ALL ON ' || quote_ident(r.table_schema) || '.'
|| quote_ident(r.table_name) || ' TO webuser';
END LOOP;
END$$;
</programlisting></para>
Searching further for similar issues I found this:
RETURNS BOOLEAN AS $$
DECLARE passed BOOLEAN;
BEGIN
Same case. Shall I write a patch for this?
Source: https://www.postgresql.org/docs/current/sql-createfunction.html
Regards,
Oli
--
FromDual - Neutral and vendor independent MariaDB, MySQL and PostgreSQL services.
FromDual GmbH Rebenweg 6
CH - 8610 Uster
Oli Sennhauser CEO / Senior Consultant
Phone: +41 44 500 58 20 Mobile: +41 79 830 09 33
oli.sennhauser@fromdual.com https://www.fromdual.com
Twitter: fromdual
Attachments:
[application/pgp-keys] OpenPGP_0xB58CF11D3C9DDEA9.asc (1.7K, ../777637c4-9d31-498d-a8ef-645fb510bf5a@fromdual.com/2-OpenPGP_0xB58CF11D3C9DDEA9.asc)
download
[application/pgp-signature] OpenPGP_signature.asc (494B, ../777637c4-9d31-498d-a8ef-645fb510bf5a@fromdual.com/3-OpenPGP_signature.asc)
download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: oli.sennhauser@fromdual.com, pgsql-docs@lists.postgresql.org
Subject: Re: Little formatting issues in doc
In-Reply-To: <777637c4-9d31-498d-a8ef-645fb510bf5a@fromdual.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox