Re: Record order change after update

Поиск
Список
Период
Сортировка
От Matt Davies
Тема Re: Record order change after update
Дата
Msg-id 1078266041.404508b99b77e@www.mattdavies.net
обсуждение исходный текст
Ответ на Record order change after update  (Josué Maldonado <josue@lamundial.hn>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Record order change after update
Следующее
От: scrappy@PostgreSQL.org
Дата:
Сообщение: Hokki =)