X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9CF709FB53B for ; Fri, 1 Sep 2006 18:57:15 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 39316-01 for ; Fri, 1 Sep 2006 18:56:33 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from zeus.gigaweb.cz (zeus.gigaweb.cz [81.0.236.19]) by postgresql.org (Postfix) with SMTP id 595329FB5CD for ; Fri, 1 Sep 2006 17:25:49 -0300 (ADT) Received: (qmail 28694 invoked from network); 1 Sep 2006 20:25:49 -0000 Received: from unknown (HELO ?192.168.1.101?) (89.102.195.231) by 0 with SMTP; 1 Sep 2006 20:25:49 -0000 Message-ID: <44F89746.2010903@fuzzy.cz> Date: Fri, 01 Sep 2006 22:25:42 +0200 From: Tomas Vondra User-Agent: Mail/News 1.5 (X11/20060424) MIME-Version: 1.0 CC: pgsql-sql@postgresql.org Subject: Re: help with pagila References: <32cabba0609010631t233d13f9o38edba0483a2446c@mail.gmail.com> <20060901152116.GE17178@phlogiston.dyndns.org> <32cabba0609011026r6616a73bhe80b336f18aa84ac@mail.gmail.com> In-Reply-To: <32cabba0609011026r6616a73bhe80b336f18aa84ac@mail.gmail.com> X-Enigmail-Version: 0.94.0.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200609/8 X-Sequence-Number: 26219 > So I can assume that the MySQL implementation is strange? (It accepts > that kind of query) Yes, MySQL behaves strangely in this case (as well as in several other cases). I wouldn't rely on this as it probably can choose different values each time (although as far as I remember I haven't seen this). t.v.