From: | lucas(at)presserv(dot)org |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: New record position |
Date: | 2005-03-30 16:17:18 |
Message-ID: | 20050330131718.3w6hptxfu408oskw@www.presserv.org |
Views: | Whole Thread | Raw Message | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)sai(dot)msu(dot)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(at)presserv(dot)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???
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-03-30 16:31:38 | Re: RE : Foreign key |
Previous Message | PFC | 2005-03-30 14:19:29 | Re: New record position |