| 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 |
| 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" |