Re: Record order change after update - Mailing list pgsql-general

From Matt Davies
Subject Re: Record order change after update
Date
Msg-id 1078266041.404508b99b77e@www.mattdavies.net
Whole thread Raw
In response to Record order change after update  (Josué Maldonado <josue@lamundial.hn>)
List pgsql-general
My understanding of RDBMs:

you will get all information as indicated by the query in an unsorted order.
Sometimes you get the same order; sometimes you do not.

To ensure expected ordering you must use the ORDER keyword.






Quoting Josué Maldonado <josue@lamundial.hn>:

> Hello list,
>
> After update a column on a table, that row goes to the top when I do a
> select from that table without any order, is that the expected behavior
> in postgresql? is there a way to prevent it?
>
> Thanks in advance.
>
> Josué Maldonado
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>




pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Record order change after update
Next
From: scrappy@PostgreSQL.org
Date:
Subject: Hokki =)