Re: New record position - Mailing list pgsql-sql

From lucas@presserv.org
Subject Re: New record position
Date
Msg-id 20050330131718.3w6hptxfu408oskw@www.presserv.org
Whole thread Raw
In response to Re: New record position  (Oleg Bartunov <oleg@sai.msu.su>)
List pgsql-sql
Okay, I will use the "order by" clause.
I was worried about it. I have thought that my database had crashed.
Thank you.

Quoting Oleg Bartunov <oleg@sai.msu.su>:

> This is a feature of relational databases, you should explicitly specify
> ordering  if you want  persistent order.
> btw, why do you bothering ?
>
>      Oleg
> On Wed, 30 Mar 2005 lucas@presserv.org wrote:
>

>> Hello, ....
>> INSERT into tb1 values ('rec3','vl3');
>> SELECT * from tb1;
>> f1    |   f2
>> ------|--------
>> rec1  | vl1
>> rec3  | vl3      <<=====
>> rec2  | vl2
>>
>> Why it? I can't undestand why the new record location was change. 
>> Shouldn't it apper at the LAST record???




pgsql-sql by date:

Previous
From: PFC
Date:
Subject: Re: New record position
Next
From: Michael Fuhr
Date:
Subject: Re: RE : Foreign key