> > > He does ask a legitimate question though. If you are
> going to have a
> > > LIMIT feature (which of course is not pure SQL), there
> seems no reason
> > > you shouldn't be able to insert the result into a table.
> >
> >
>
> This is an interesting idea. We don't allow ORDER BY in
> INSERT INTO ...
> SELECT because it doesn't make any sense, but it does make sense if
> LIMIT is used:
An "order by" also makes sense if you want to create a presorted table
for faster access. I don't see why we should disallow it.
Andreas