Re: Clustered table order is not preserved on insert

In article <20060427001523.GR97354@pervasive.com>,
Jim C. Nasby <jnasby@pervasive.com> wrote:

% Keep reading... from the same paragraph:
%
% Clustering is a one-time operation: when the table is subsequently
% updated, the changes are not clustered.

But this isn't really relevant to the question. More to the point
is this tidbit from the documentation for SELECT:

  If the ORDER BY clause is specified, the returned rows are
  sorted in the specified order. If ORDER BY is not given, the
  rows are returned in whatever order the system finds fastest
  to produce.

This is not necessarily the order in which they're stored on disk.
--

Patrick TJ McPhee
North York  Canada
ptjm@interlog.com