On Wednesday, January 11, 2023, PG Bug reporting form <
noreply@postgresql.org> wrote:
The following bug has been logged on the website:
Bug reference: 17745
Logged by: Paweł Podgórski
Email address: pawel.jan.podgorski@gmail.com
PostgreSQL version: 14.5
Operating system: Windows 11
Description:
When I try to "INSERT INTO .... RETURNING (channel)" the output is:
channel
--------------
3o0mNjcS4CMr
(1 row)
But RETURNING multiple attributes produces another output:
"INSERT INTO .... RETURNING ( channel , last_processing_timestamp,
last_successful_processing_timestamp )"
row
--------------------------------------------------------------------------------
(3o0mNjcS4CMr,"2023-01-11 12:01:40.016988+01","2023-01-11
12:01:40.016988+01")
(1 row)
The output that is expected is similar to:
"INSERT INTO .... RETURNING channel , last_processing_timestamp,
last_successful_processing_timestamp "
channel | last_processing_timestamp |
last_successful_processing_timestamp
--------------+-------------------------------+--------------------------------------
3o0mNjcS4CMr | 2023-01-11 12:01:40.016988+01 | 2023-01-11
12:01:40.016988+01
(1 row)
If you don’t want a composite returned don’t put parentheses around the column list.
David J.