Re: New record position

Поиск
Список
Период
Сортировка
От Chris Browne
Тема Re: New record position
Дата
Msg-id 60br90spl0.fsf@dba2.int.libertyrms.com
обсуждение исходный текст
Ответ на New record position  (lucas@presserv.org)
Ответы Re: New record position  ("Greg Patnude" <gpatnude@hotmail.com>)
Список pgsql-sql
lucas@presserv.org writes:
> Why it? I can't undestand why the new record location was change. Shouldn't it
> apper at the LAST record???
> What need I do??

SQL only imposes an order on the return set if you add an "ORDER BY"
clause.

You can't expect any particular order to either recur or NOT recur
unless you have specifically requested a particular ordering.

There's no bug; just use ORDER BY if you need to, and, if you don't,
make sure you don't expect any particular ordering...
-- 
(format nil "~S@~S" "cbbrowne" "cbbrowne.com")
http://www3.sympatico.ca/cbbrowne/spiritual.html
"The  present  need for  security  products far exceeds  the number of
individuals    capable of    designing  secure  systems. Consequently,
industry  has resorted to  employing folks  and purchasing "solutions"
from vendors that shouldn't be let near a project involving securing a
system."  -- Lucky Green


В списке pgsql-sql по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
Следующее
От: "林[鋅"
Дата:
Сообщение: A SQL Question About distinct, limit, group by, having, aggregate