Update Query doesn't affect all records

From: "Schindler Andor" <schindler(dot)andor(at)pokhalo(dot)hu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Update Query doesn't affect all records
Date: 2009-08-05 12:15:55
Message-ID: 0CBB9F783B95456AAD045AEC1A8B14DE@ph.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

I've got this update query:

http://pastebin.com/m2e29990

Can anyone tell me, how this is possible? If we insert 12 on the end, then
it decreases, but 11 remains the same. The problem only occurs, when the
where condition contains "sorrend > 9" or less.

It occured using "PostgreSQL 8.3.3, compiled by Visual C++ build 1400" and
"PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian
4.3.2-1.1) 4.3.2" too.

Thanks,
Andor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2009-08-05 12:56:08 Re: Update Query doesn't affect all records
Previous Message Bill Moran 2009-08-05 12:02:13 Re: Does derby have an embedded Mode like Derby ?