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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
