SELECT List with/without parentheses

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

Responses

Browse pgsql-docs by date

  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