X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 2CC33D1B56B for ; Fri, 5 Sep 2003 12:26:06 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 30134-01 for ; Fri, 5 Sep 2003 09:25:37 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 01144D1B8A4 for ; Fri, 5 Sep 2003 09:25:32 -0300 (ADT) Received: (qmail 10598 invoked by uid 500); 5 Sep 2003 12:31:50 -0000 Date: Fri, 5 Sep 2003 07:31:50 -0500 From: Bruno Wolff III To: Chris FR Cc: pgsql-php@postgresql.org Subject: Re: Strange browser behavior when querying PostgreSql database Message-ID: <20030905123150.GA10433@wolff.to> Mail-Followup-To: Chris FR , pgsql-php@postgresql.org References: <2a584f81.0309020650.6457780e@posting.google.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <2a584f81.0309020650.6457780e@posting.google.com> User-Agent: Mutt/1.5.4i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/16 X-Sequence-Number: 2293 On Tue, Sep 02, 2003 at 07:50:15 -0700, Chris FR wrote: > > SELECT a.* FROM a WHERE a.idf = b.id You shouldn't use the above syntax as it is non standard and is more commonly used by mistake than intentionally. People looking at your code later will wonder what you were really trying to do. > I solved the problem by modifying the request : > > SELECT a.* FROM a, b WHERE a.idf = b.id > > Now the script works. I am not sure why there is a difference in these two cases. Possibly you didn't give us the real queries and there is something else going on.