Henrique Engelmann <henriqueengelmann@xxxxxxxxxxxx> writes: > I suggested changing the application and including a order by clause... but > the software house didn´t make it because they said the system was originally designed for oracle and they did not need to use the ORDER BY clause with Oracle and even so the data were always retrieved in primary index order. > I´m thinking with myself ... what kind of problems will they have in the future? If you aren't working with these people any more, be glad. They are obviously utterly incompetent. The SQL standard is perfectly clear about the matter: without ORDER BY, there is no guarantee about the order in which rows are retrieved. The fact that one specific implementation might have chanced to produce the rows in desired order (under all the conditions they had bothered to test, which I bet wasn't a lot) does not make their code correct. regards, tom lane
