Re: Update Query doesn't affect all records

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Schindler Andor <schindler(dot)andor(at)pokhalo(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Update Query doesn't affect all records
Date: 2009-08-05 12:56:08
Message-ID: dcc563d10908050556q560975b5x8f9c8f0f6c57b91f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 5, 2009 at 6:15 AM, Schindler
Andor<schindler(dot)andor(at)pokhalo(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Csaba Nagy 2009-08-05 12:56:47 Re: Update Query doesn't affect all records
Previous Message Schindler Andor 2009-08-05 12:15:55 Update Query doesn't affect all records