Re: Insert into and Sequence

Поиск
Список
Период
Сортировка
От Ireneusz Pluta
Тема Re: Insert into and Sequence
Дата
Msg-id 47691AD9.5070704@wp.pl
обсуждение исходный текст
Ответ на Insert into and Sequence  (Luigi Pirillo <luigi.pirillo@gmail.com>)
Список pgsql-sql
<blockquote cite="mid:4766CE38.6060904@gmail.com" type="cite"><tt><br /> Apparently, new records are not inserted in
thetable according to the order selected by "Test_Step_Id" field; <br /></tt></blockquote><tt>As seen in: <a
class="moz-txt-link-freetext"href="http://en.wikipedia.org/wiki/SQL:">http://en.wikipedia.org/wiki/SQL:</a><br /> "The
orderof rows returned by an SQL query is never guaranteed unless an <code>ORDER BY</code> clause is specified".<br
/><br/> In other words, a database system does not guarantee you the order in which table rows are stored. So, the
orderin which you insert your rows is not the one which has to be followed when selecting them afterwards. You must
specifyby "ORDER BY" how you want to sort your recordset.<br /><br /> It seems you need to revisit the concept of your
system.<br/><br /> Best regards<br /><br /> Irek<br /></tt><br /> 

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

Предыдущее
От: Steve Midgley
Дата:
Сообщение: Re: System catalog future changes
Следующее
От: Jeff Trout
Дата:
Сообщение: DBLink or setof record functions & type shortcuts