| From: | Michael_LT <michaelbleedgreen(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to convert "output deleted/inserted into" in MySQL to Postgres |
| Date: | 2015-02-20 21:41:23 |
| Message-ID: | 1424468483637-5838771.post@n5.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
hey, john, i did as you said like:
update db.user
set deleted = 1,
updateterminal = UpdateTerminal,
updateuser = UpdateUser,
updatedate = UpdateDate
returning
credittypeid,
creditid,
amount
into ReconDeleted
where deleted = 0
and clientid = ClientID
);
I have ERROR: syntax error at or near "into"
ReconDeleted has three columns
CreditTypeID bigint,
CreditID bigint,
Amount money
--
View this message in context: http://postgresql.nabble.com/How-to-convert-output-deleted-inserted-into-in-MySQL-to-Postgres-tp5838762p5838771.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2015-02-20 21:45:29 | Re: Re: How to convert "output deleted/inserted into" in MySQL to Postgres |
| Previous Message | John R Pierce | 2015-02-20 21:07:39 | Re: How to convert "output deleted/inserted into" in MySQL to Postgres |