X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E66E0D1DBFA for ; Sun, 18 Apr 2004 15:37:57 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 08680-01 for ; Sun, 18 Apr 2004 15:37:57 -0300 (ADT) Received: from web11.manitu.net (web11.manitu.net [217.11.48.111]) by svr1.postgresql.org (Postfix) with ESMTP id 8E37AD1DB96 for ; Sun, 18 Apr 2004 15:37:55 -0300 (ADT) Received: from [192.168.0.1] (dsl-082-082-191-125.arcor-ip.net [82.82.191.125]) (authenticated) by web11.manitu.net (8.10.2-SOL3/8.10.2) with ESMTP id i3IIbnM01568; Sun, 18 Apr 2004 20:37:49 +0200 Subject: Re: problem porting MySQL SQL to Postgres From: Markus Bertheau To: Paul Thomas Cc: Dan Field , "pgsql-sql @ postgresql . org" In-Reply-To: <20040415121523.A864@bacon> References: <4A063822-8EC7-11D8-9677-000A958E367A@llgc.org.uk> <20040415121523.A864@bacon> Content-Type: text/plain; charset=UTF-8 Message-Id: <1082313473.2263.0.camel@yarrow.bertheau.de> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-1) Date: Sun, 18 Apr 2004 20:37:53 +0200 Content-Transfer-Encoding: quoted-printable X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/155 X-Sequence-Number: 17530 =D0=92 =D0=A7=D1=82=D0=B2, 15.04.2004, =D0=B2 13:15, Paul Thomas =D0=BF=D0= =B8=D1=88=D0=B5=D1=82: > On 15/04/2004 11:25 Dan Field wrote: > Your "=3D NULL" tests are also not valid SQL (should be IS NULL). I think =3D NULL _is_ valid SQL, it just doesn't do what you think. --=20 Markus Bertheau