"Raul DAVIDOVICH" <R(dot)DAVIDOVICH(at)cvitkovic-ac(dot)fr> writes:
> I'm having a problem when updating a row.. after comiting the change,
> the row appears at the end of the list, and from there on, it stays there
> until the next update.
> This happens when using both JDBC or psql. Normally, rows shouldn't
> change the order after updates. Am I messing it up with the indexes?
You are mistaken to assume that the row order is stable. SQL guarantees
*nothing* about row order unless you use ORDER BY to constrain the
result of a SELECT.
regards, tom lane