On 4/3/2016 4:34 PM, Dave Cramer wrote:
I'm not sure if you're serious or if you're just trying to be "cute". This ticket should still be fixed. It really doesn't make any sense to me that the driver will just blindly append "RETURNING *" to the query.
If I want to return all of the columns from an UPDATE or an INSERT -- then I will add "RETURNING *" myself. And if I don't add it, then I probably don't want the driver to second guess me, or to think that it knows better than I do what I want. If I wanted software that thinks that it knows what I want better than I do -- then I would stick with SQL Server rather than switch to Postgres.
The driver used to work until someone decided to append "RETURNING *" to the SQL code and make it unusable in many cases.
Was there any discussion on this before it was added?