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 724C8D1B89F for ; Fri, 5 Sep 2003 13:26:23 +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 35372-08 for ; Fri, 5 Sep 2003 10:26:16 -0300 (ADT) Received: from serdyn (7xxxx7.redshift.co.za [66.8.87.226]) by svr1.postgresql.org (Postfix) with SMTP id D5CC8D1B8B7 for ; Fri, 5 Sep 2003 10:26:08 -0300 (ADT) X-Flags: 0000 Received: (qmail 21443 invoked by uid 65534); 5 Sep 2003 12:33:28 -0000 Received: from 215.commandprompt.com (EHLO hosting.commandprompt.com) (207.173.200.215) by mx0.gmx.net (mx034-rz3) with SMTP; 05 Sep 2003 14:33:28 +0200 Received: from postgresql.org (svr1.postgresql.org [64.117.224.193]) by hosting.commandprompt.com (8.11.6/8.11.6) with ESMTP id h85CWj208485 for ; Fri, 5 Sep 2003 05:33:11 -0700 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: <6419763.1062768118515.JavaMail.Administrator@serdyn> 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-Mailing-List: pgsql-php Precedence: bulk X-GMX-Antivirus: -1 (not scanned, may not use virus scanner) X-GMX-Antispam: 0 (Mail was not recognized as spam) X-fetched-from: gmx.net Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/18 X-Sequence-Number: 2295 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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)