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 [EMAIL PROTECTED] 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???
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
