weirdness with the a sql update

From: Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: weirdness with the a sql update
Date: 2005-08-04 14:19:44
Message-ID: 42F22400.40306@amsoftwaredesign.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-04 14:29:03 Re: What happens when wal fails?
Previous Message Alejandro D. Burne 2005-08-04 11:38:00 Re: pgsql-odbc list problem