From: lucas@presserv.org
To: Oleg Bartunov <oleg@sai.msu.su>
Cc: pgsql-sql@postgresql.org
Subject: Re: New record position
Date: Wed, 30 Mar 2005 13:17:18 -0300
Message-ID: <20050330131718.3w6hptxfu408oskw@www.presserv.org> (raw)
In-Reply-To: <Pine.GSO.4.62.0503301809570.17555@ra.sai.msu.su>
References: <20050330105017.miuieky7u64gscgc@www.presserv.org>
<Pine.GSO.4.62.0503301809570.17555@ra.sai.msu.su>
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???
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: lucas@presserv.org, oleg@sai.msu.su
Subject: Re: New record position
In-Reply-To: <20050330131718.3w6hptxfu408oskw@www.presserv.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox