>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 > , UpdateUser = @UpdateUser > , UpdateDate = @UpdateDate > output deleted.CreditTypeID > , deleted.CreditID > , deleted.Amount > into @ReconDeleted > where Deleted = 0 > and ClientID = @ClientID; > >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 don't think we have those in pg. Can someone >tell me how to convert it? Thanks. Hi, it seems that you are looking for UPDATE RETURNING: http://www.postgresql.org/docs/9.4/static/sql-update.html regards, Marc Mamin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
