"Aurangzeb M. Agha" <aagha(at)bigfoot(dot)com> writes:
> I've noticed that whenever I update a record in the table and do a select
> * to see my change, that the updated racord has dropped to the bottom of
> the table.
>
> Is there either a) a (simple) way to keep this from happening or b)
> putting the record back where it "belongs" after an update.
Postgres (and most other SQL databases) makes no guarantee about the
order of results from a SELECT unless you use an ORDER BY clause. So
put ORDER BY in your query if you care about the display order.
-Doug