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 7BAECD1D52E for ; Sun, 18 Apr 2004 16:24:52 -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 19255-01 for ; Sun, 18 Apr 2004 16:24:52 -0300 (ADT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by svr1.postgresql.org (Postfix) with ESMTP id 38C36D1BB49 for ; Sun, 18 Apr 2004 16:24:50 -0300 (ADT) Received: from tmsl-adsl.demon.co.uk ([80.177.114.181] helo=bacon.tmsl.demon.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 1BFHuN-000J6i-0X; Sun, 18 Apr 2004 20:24:51 +0100 Date: Sun, 18 Apr 2004 20:24:47 +0100 From: Paul Thomas To: Markus Bertheau Cc: Dan Field , "pgsql-sql @ postgresql . org" Subject: Re: problem porting MySQL SQL to Postgres Message-ID: <20040418202447.A16735@bacon> References: <4A063822-8EC7-11D8-9677-000A958E367A@llgc.org.uk> <20040415121523.A864@bacon> <1082313473.2263.0.camel@yarrow.bertheau.de> Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset=ISO-8859-1 In-Reply-To: <1082313473.2263.0.camel@yarrow.bertheau.de>; from twanger@bluetwanger.de on Sun, Apr 18, 2004 at 19:37:53 +0100 X-Mailer: Balsa 1.2.3 Lines: 24 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200404/156 X-Sequence-Number: 17531 On 18/04/2004 19:37 Markus Bertheau wrote: > В Чтв, 15.04.2004, в 13:15, Paul Thomas пишет: > > On 15/04/2004 11:25 Dan Field wrote: > > > Your "= NULL" tests are also not valid SQL (should be IS NULL). > > I think = NULL _is_ valid SQL, it just doesn't do what you think. It's valid in an assignment update foo set bar = null; PostgreSQL can be coerced into accepting where foo = null with the transform_null_equals run-time option but that doesn't make it legal SQL IFAIK. -- Paul Thomas +------------------------------+---------------------------------------------+ | Thomas Micro Systems Limited | Software Solutions for Business | | Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk | +------------------------------+---------------------------------------------+