Thank you Larry and Dennis! Now I clearly understand that doing what I did is NOT SAFE ...
Bo Franzén Department of Economic History University of Stockholm On 2008-10-31, at 15:20, Lawrence Lustig wrote: > << > I have then been using the > PROJECT command at the R>prompt in order to make a copy of the table using the > ORDER OF parameter (R>PROJECT newtable FROM table USING * ORDER OF > primaryindex > ASC). >>> > > > If the purpose of this is to obtain a table which will return rows in Primay Key order without having to use an ORDER BY clause, you should be aware that this is NOT SAFE. While R:Base will USUALLY return the rows in the order you want, it doesn't PROMISE to, and this behavior could change at any point in the future without notice. Additionally, there are times even now when R:Base will return data in a different order -- for instance, when the request can be satisfied entirely from an existing index (index only retrieval). > -- > Larry > >
