[HACKERS] UPDATE .. RETURNING OLD.*

2009-08-28 Thread Marko Tiikkaja
Hi everyone, Today I needed a feature like $subject. The use case was: UPDATE foo SET bar = bar + 1 WHERE id=$1, but I wanted to only do it when bar was 0. In order to give the user an informative error message, I also needed to distinguish the two cases: a row with id = $1 doesn't exist, and

Re: [HACKERS] UPDATE .. RETURNING OLD.*

2009-08-28 Thread David Fetter
On Fri, Aug 28, 2009 at 06:12:30PM +0300, Marko Tiikkaja wrote: Hi everyone, Today I needed a feature like $subject. The use case was: UPDATE foo SET bar = bar + 1 WHERE id=$1, but I wanted to only do it when bar was 0. In order to give the user an informative error message, I also needed