|Subject||Re: [firebird-support] toggle betweenn 0 and 1|
That's the most simple formula Josef but requires that COLUMN always be 1 or 0, never another number neither NULL.
On Thu, Apr 3, 2014 at 1:06 AM, Josef Kokeš <j.kokes@...> wrote:
On 2.4.2014 9:26, Bogdan Mihalache wrote:
> Update table set *column = Mod(column+1,2)* where id = :id
UPDATE table SET column=1-column WHERE id=:id
Doesn't need any functions, built-in or UDF.