Little formatting issues in doc

From: Oli Sennhauser <oli(dot)sennhauser(at)fromdual(dot)com>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Little formatting issues in doc
Date: 2026-09-29 09:20:06
Message-ID: 777637c4-9d31-498d-a8ef-645fb510bf5a@fromdual.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-docs

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(dot)sennhauser(at)fromdual(dot)com https://www.fromdual.com
Twitter: fromdual

Attachment Content-Type Size
OpenPGP_0xB58CF11D3C9DDEA9.asc application/pgp-keys 1.7 KB

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message David Rowley 2026-09-29 12:47:54 Re: [Minor] Clarification on "2.7. Aggregate Functions"
Previous Message David G. Johnston 2026-09-28 19:35:04 Re: [Minor] Conflicting sentence in "2.4. Populating a Table With Rows"