Re: [GENERAL] How to convert "output deleted/inserted into" in MySQL to Postgres

2015-02-20 Thread Thomas Kellerer
Tong Michael wrote on 20.02.2015 21:59: hey guys, I'm kinda new to Postgres and I'm learning it now. I have work to convert some stored procedures in MySQL to Postgres and I came across an issue here that I can't solve: update db.user set Deleted= 1 , Update

Re: [GENERAL] How to convert "output deleted/inserted into" in MySQL to Postgres

2015-02-20 Thread John R Pierce
On 2/20/2015 12:59 PM, Tong Michael wrote: I think it tried to update a couple of columns in table user and insert values in other 3 columns into another table ReconDeleted at the same time. I have issues converting "OUTPUT INTO" and "deleted" items, with my limited knowledge about Postgres, I

[GENERAL] How to convert "output deleted/inserted into" in MySQL to Postgres

2015-02-20 Thread Tong Michael
hey guys, I'm kinda new to Postgres and I'm learning it now. I have work to convert some stored procedures in MySQL to Postgres and I came across an issue here that I can't solve: update db.user set Deleted= 1 , UpdateTerminal = @UpdateTerminal , Upda