Re: Order of rows in temp tables

On Wed, 17 Jun 1998 16:03:00 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >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?!?!?!??!?!?!????!?!??!?! Yes. Quite often. > >Art S. Kagel Nils Myklebust NM Data AS Norway E-mail: Nils.Myklebust@nmdata.com FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html (Now with ODBC info under "Third party products".)