| From: | Tong Michael <michaelbleedgreen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | How to convert "output deleted/inserted into" in MySQL to Postgres |
| Date: | 2015-02-20 20:59:30 |
| Message-ID: | CAHVHtZ-hD8kdTVJJBQgK7g4x6fkgycAe8Bv7Ajj4DUP1U3HRBQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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.
PS: it's my first time using this form, nice to meet you guys:)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2015-02-20 21:07:39 | Re: How to convert "output deleted/inserted into" in MySQL to Postgres |
| Previous Message | Michael_LT | 2015-02-20 19:57:37 | how to convert "output deleted/inserted into" in My SQL to Postgres |