SELECT List with/without parentheses

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема SELECT List with/without parentheses
Дата
Msg-id 175702516430.356921.959597202664413151@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: SELECT List with/without parentheses
Re: SELECT List with/without parentheses
Список 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

В списке pgsql-docs по дате отправления: