Re: How to convert "output deleted/inserted into" in MySQL to Postgres - Mailing list 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.