Re: Order of rows in temp tables

Posted in 1998

Art S. Kagel — Wed, 17 Jun 1998 16:03:00 -0400 — source: Informix-list mailing list archive (1991-1998)

Nils Myklebust wrote: > > On Mon, 15 Jun 1998 16:11:51 CDT, "Sunil Thakkar" <sunil0@hotmail.com> > wrote: > > >Martin Brassard wrote: > >[SNIP] > > No is the simple answer. The relational theory says so and then it is > so. Simple. Although SQL doesn't exactly implement relational theory > very well, in this case it does. There is no defined order to the > returned rows of any select statement unless you use an order by. Off topic Nils, but, doesn't it seem that Relational Databases in general, Informix no more or less than any other, always adher to or ignore whatever part of the theory will produce the most programmer and administrator grief and annoyance?!?!?!??!?!?!????!?!??!?! Art S. Kagel