Re: New record position

> 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??
> Thank you.

The SQL spec specifies that if you don't use ORDER BY, well, the records  
come out in any order they want. Actually it's the order they are on disk,  
which is more or less random as inserting new records will fill the space  
left by deleted ones, and vacuum full will compact them. If you want  
order, use ORDER BY. If you want to order them in the order they were  
inserted, order by a SERIAL PRIMARY KEY field...