Re: New record position - Mailing list pgsql-sql

From Chris Browne
Subject Re: New record position
Date
Msg-id 60br90spl0.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to New record position  (lucas@presserv.org)
Responses Re: New record position
List 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 by date:

Previous
From: Greg Stark
Date:
Subject: Re: can you change an FK constraint from NOT DEFERRABLE to DEFERRABLE
Next
From: "林[鋅"
Date:
Subject: A SQL Question About distinct, limit, group by, having, aggregate