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

From Tony Caduto
Subject weirdness with the a sql update
Date
Msg-id 42F22400.40306@amsoftwaredesign.com
Whole thread Raw
In response to Re: pgsql-odbc list problem  ("Alejandro D. Burne" <alejandro.dburne@gmail.com>)
Responses Re: weirdness with the a sql update  (Martijn van Oosterhout <kleptog@svana.org>)
Re: weirdness with the a sql update  (Douglas McNaught <doug@mcnaught.org>)
Re: weirdness with the a sql update  (Sven Willenberger <sven@dmv.com>)
Re: weirdness with the a sql update  (Michael Fuhr <mike@fuhr.org>)
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

>
>


pgsql-general by date:

Previous
From: "Alejandro D. Burne"
Date:
Subject: Re: pgsql-odbc list problem
Next
From: Tom Lane
Date:
Subject: Re: What happens when wal fails?