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.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
