Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.php > #15199

Re: Problem creating a series of tables

Path csiph.com!usenet.pasdenom.info!weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail
From Thomas 'PointedEars' Lahn <PointedEars@web.de>
Newsgroups comp.lang.php
Subject Re: Problem creating a series of tables
Date Fri, 03 Apr 2015 20:45:54 +0200
Organization PointedEars Software (PES)
Lines 29
Message-ID <13354939.iucU4XV5EG@PointedEars.de> (permalink)
References <arrknd1koidz.1uimiwnq5sefe.dlg@40tude.net> <mfet7b$qs$1@dont-email.me> <1957209.MyoqzTBkhW@PointedEars.de> <mfjj60$5nq$2@dont-email.me> <1928459.l4EcNPIvok@PointedEars.de> <2535888.CQyUAPWPjF@PointedEars.de> <mfkkc0$7jr$1@solani.org>
Reply-To Thomas 'PointedEars' Lahn <php@PointedEars.de>
Mime-Version 1.0
Content-Type text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding 7Bit
X-Trace solani.org 1428086875 31287 eJwNyMkBwDAIA7CVuGzoOCmB/Udo9RScys4gGFjs3hi5YDu2WGbvdJ0jM6xJ+atcslUfhBjtAyNuEH0= (3 Apr 2015 18:47:55 GMT)
X-Complaints-To abuse@news.solani.org
NNTP-Posting-Date Fri, 3 Apr 2015 18:47:55 +0000 (UTC)
User-Agent KNode/4.14.2
X-User-ID eJwFwQEBACAIA7BKIvzXOCjYP4IbnMarIBh4eEtRVx22WjNLCexhQ8dvryjQdxmkfG7sWcdmbvoZrsENfj/WFH4=
Cancel-Lock sha1:/dyC2C8pge1X11iKFivpSDZGJnc=
X-NNTP-Posting-Host eJwNx8kBwCAIBMCWUA6xnAC7/Zdg5jeusaKPhYc5nVobGJXC1MAFkbGv9G3LbcXWNci/II3nezeoElk=
Xref csiph.com comp.lang.php:15199

Show key headers only | View raw

Christoph M. Becker wrote:

> Thomas 'PointedEars' Lahn wrote:
>> I realize that this is not a good test.
>> [...]
>> Conclusion: The result records are sorted by primary key.  Q.E.D.
> 
> Even a perfect test would always give implementation specific results,
> which might be subject to change. 

Yes, of course, which is why I have given the details of my test 
environment.  My posting should not be misconstrued to mean that
you can always omit ORDER BY if you defined an index.

> FWIW, the SQL 92 specification[1] states in section 20.2 <direct select 
> statement: multiple rows>:
> 
> | If an <order by clause> is not specified, then the ordering of
> | the rows of Q is implementation-dependent.
> 
> [1] <http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt>

Thanks.

-- 
PointedEars
Zend Certified PHP Engineer
Twitter: @PointedEars2
Please do not cc me. / Bitte keine Kopien per E-Mail.

Back to comp.lang.php | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Problem creating a series of tables richard <noreply@example.com> - 2015-03-31 12:14 -0400
  Re: Problem creating a series of tables Paul Herber <paul@pherber.com> - 2015-03-31 19:09 +0100
    Re: Problem creating a series of tables richard <noreply@example.com> - 2015-03-31 14:30 -0400
  Re: Problem creating a series of tables Denis McMahon <denismfmcmahon@gmail.com> - 2015-03-31 19:40 +0000
    Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-03-31 16:19 -0400
      Re: Problem creating a series of tables Richard Yates <richard@yatesguitar.com> - 2015-03-31 18:07 -0700
        Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-03-31 21:23 -0400
      Re: Problem creating a series of tables Erwin Moller <erwinmollerusenet@xs4all.nl> - 2015-04-01 12:19 +0200
        Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-02 15:23 +0200
          Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 10:17 -0400
    Re: Problem creating a series of tables richard <noreply@example.com> - 2015-03-31 20:14 -0400
      Re: Problem creating a series of tables Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-01 02:44 +0000
        Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-03-31 23:06 -0400
          Re: Problem creating a series of tables richard <noreply@example.com> - 2015-04-01 00:09 -0400
            Re: Problem creating a series of tables Doug Miller <doug_at_milmac_dot_com@example.com> - 2015-04-01 20:37 +0000
              Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-01 17:08 -0400
    Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-02 14:50 +0200
      Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 10:20 -0400
        Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-02 22:32 +0200
          Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-03 00:44 +0200
            Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 19:22 -0400
            Re: Problem creating a series of tables Jerry Stuckle <jstucklex@attglobal.net> - 2015-04-02 19:24 -0400
            Re: Problem creating a series of tables "Christoph M. Becker" <cmbecker69@arcor.de> - 2015-04-03 01:46 +0200
              Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-03 20:45 +0200
          Re: Problem creating a series of tables Richard Yates <richard@yatesguitar.com> - 2015-04-02 15:59 -0700
            Re: Problem creating a series of tables Thomas 'PointedEars' Lahn <PointedEars@web.de> - 2015-04-03 01:10 +0200
              Re: Problem creating a series of tables Richard Yates <richard@yatesguitar.com> - 2015-04-02 18:44 -0700

csiph-web