Re: Insert into and Sequence - Mailing list pgsql-sql

From Ireneusz Pluta
Subject Re: Insert into and Sequence
Date
Msg-id 47691AD9.5070704@wp.pl
Whole thread Raw
In response to Insert into and Sequence  (Luigi Pirillo <luigi.pirillo@gmail.com>)
List 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 by date:

Previous
From: Steve Midgley
Date:
Subject: Re: System catalog future changes
Next
From: Jeff Trout
Date:
Subject: DBLink or setof record functions & type shortcuts