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 по дате отправления: