Subject | Re: [firebird-support] Re: Altering Primary Key on Table |
---|---|
Author | Ann W. Harrison |
Post date | 2005-09-01T16:16:43Z |
Tony Masefield wrote:
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
> To answer Helen's question 'Why', it's because the table will beAs Ivan points out, that won't work. Let me be even more clear. In the
> 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.
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