Subject Re: [firebird-support] Re: Altering Primary Key on Table
Author Ann W. Harrison
Tony Masefield wrote:

> To answer Helen's question 'Why', it's because the table will be
> used 'as standard' in descending sort order, not ascending. Therefore
> it 'uncomlicates' matters where one has to remember to add an ORDER BY
> clause each time the table is used in an application.

As Ivan points out, that won't work. Let me be even more clear. In the
absence of an ORDER BY clause, data is returned in storage order, which
is generally FIFO, but can have random variations when a new record is
stored in space released by old records.

Regards,


Ann