weirdness with the a sql update - Mailing list pgsql-general

Hi,

I just noticed this, if I do a update like this:

update new_requests set name = 'tony' where request_id = 2

If I do a select * from new_requests that record I just updated is now
at the bottom , before the update it was at the top?

Why is Postgresql changing the ordering of the results after a simple
update?
It almost looks like the record is being dropped and then readded to the
end.

Thanks,

Tony

>
>