Re: Update Query doesn't affect all records

From: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
To: Schindler Andor <schindler(dot)andor(at)pokhalo(dot)hu>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Update Query doesn't affect all records
Date: 2009-08-05 12:56:47
Message-ID: 1249477007.28101.19.camel@pcd12478
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Andor,

On Wed, 2009-08-05 at 14:15 +0200, Schindler Andor wrote:
> 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.

I bet the "sorrend" column is of some text type, and the "sorrend > 9"
comparison is a text comparison. Try "sorrend::integer > 9" and it
should work ;-)

Cheers,
Csaba.

In response to

Responses

Browse pgsql-general by date

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