Re: Update Query doesn't affect all records - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Update Query doesn't affect all records
Date
Msg-id dcc563d10908050556q560975b5x8f9c8f0f6c57b91f@mail.gmail.com
Whole thread Raw
In response to Update Query doesn't affect all records  ("Schindler Andor" <schindler.andor@pokhalo.hu>)
List pgsql-general
On Wed, Aug 5, 2009 at 6:15 AM, Schindler
Andor<schindler.andor@pokhalo.hu> wrote:
> 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.

What are the types of those fields?

pgsql-general by date:

Previous
From: "Schindler Andor"
Date:
Subject: Update Query doesn't affect all records
Next
From: Csaba Nagy
Date:
Subject: Re: Update Query doesn't affect all records