Author Svein Erling
--- In, "uwekeim" wrote:
> Hello,
> I want to insert some ordered records into an empty table, but
> Firebird seems not to support "ORDER BY" in an insert-clause (why
> not???).
> Is there any workaround?

In theory, there is no such thing as an order amongst the stored
records of Firebird. You may ask for ordered records when you take
them out of the database (SELECT... ORDER BY...), but within the
database there is approximately as much order as amongst the clothes
within a washing machine. You may find there to be a certain order
('hey, I inserted these records in this order, and it is almost what I
get out without any order by clause'), but I would not trust any such
accidental ordering unless someone deep into the source code told me
it was safe. You'd better use indexes and order your data when taking
them out of the database.