Alvaro Herrera <alvherre@xxxxxxxxxxxxxxxxx> writes: > Bill Moran wrote: >> Is it possible that your UPDATE command is updating multiple rows? I >> don't believe RETURNING will work on an UPDATE that touches more than 1 >> row. > Hmm, why not? plpgsql will reject UPDATE RETURNING INTO that returns more than one row, since it hasn't got any place to put the additional data. It wasn't clear to me whether the OP was even using plpgsql, but if he was, the example should have worked. We'd need to see more detail to guess what the real problem is. regards, tom lane
