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

From Csaba Nagy
Subject Re: Update Query doesn't affect all records
Date
Msg-id 1249477007.28101.19.camel@pcd12478
Whole thread Raw
In response to Update Query doesn't affect all records  ("Schindler Andor" <schindler.andor@pokhalo.hu>)
Responses Re: Update Query doesn't affect all records
List 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.



pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Update Query doesn't affect all records
Next
From: Sam Mason
Date:
Subject: Re: Does derby have an embedded Mode like Derby ?