Subject | Re: [firebird-support] Invert two columns |
---|---|
Author | Pierre Y. |
Post date | 2003-10-29T14:50:59Z |
If this one don't works :
UPDATE TEST SET
V2=V2+V1,
V1=V2-V1,
V2=V2-V1
Incredible.
Pierre Y.
> UPDATE TEST SETThis one works well :)
> V2=V1,
> V1=V2
UPDATE TEST SET
V2=V2+V1,
V1=V2-V1,
V2=V2-V1
Incredible.
Pierre Y.