From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
Cc: | jason(at)starnull(dot)net |
Subject: | SELECT List with/without parentheses |
Date: | 2025-09-04 22:32:44 |
Message-ID: | 175702516430.356921.959597202664413151@wrigleys.postgresql.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/17/sql-select.html
Description:
Here: https://www.postgresql.org/docs/current/sql-select.html
There is no mention of the difference in PostgreSql behavior if the select
list of columns is surrounded by parentheses or not. The difference is quite
dramatic and non-obvious, especially when working with a database driver
(like pq or pqxx) where the result is packed up in a fairly opaque object.
Just some mention of how using parentheses causes a query to return a "row"
object that represents the tuple as a single string vs not using parentheses
where each column is represented individually.
Thank you for the wonderful work you do!
---Jason
From | Date | Subject | |
---|---|---|---|
Next Message | Pierrick | 2025-09-05 13:53:09 | Adding clarification on extension_control_path when extension is present in multiple folders |
Previous Message | Michael Paquier | 2025-09-04 01:28:08 | Re: Inaccurate statement about log shipping replication mode |