>
> UPDATE work
> SET result = CASE
> WHEN in1 == 0 THEN 0
> WHEN in2 == 0 THEN 0
> WHEN in1 != in2 THEN 0
> ELSE -1
> END;
I'll rephrase my question:
Is there a guarantee (maybe defined by SQL92-specs?) that in update statements
as the one above the rows are updated in table sort order?
Any answer would really be appreciated!
Daniel
P.S.
I'm running sqlite-2.8.11
--
Dipl.-Math. (FH) Daniel Franke
Institut fuer Medizinische Biometrie und Statistik
Medizinische Universität zu Luebeck
Ratzeburger Allee 160, Haus 4
23538 Luebeck
Telefon: 0451-500-2786
Telefax: 0451-500-2999
[EMAIL PROTECTED]
