Postgres Pro
Downloads
Home   >   mailing lists

Re: problem porting MySQL SQL to Postgres - Mailing list pgsql-sql

From Paul Thomas
Subject Re: problem porting MySQL SQL to Postgres
Date
Msg-id 20040418202447.A16735@bacon
Whole thread Raw
In response to Re: problem porting MySQL SQL to Postgres  (Markus Bertheau <twanger@bluetwanger.de>)
Responses Re: problem porting MySQL SQL to Postgres  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-sql
Tree view 
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   |
+------------------------------+---------------------------------------------+

pgsql-sql by date:

Previous
From: Markus Bertheau
Date:
Subject: Re: problem porting MySQL SQL to Postgres
Next
From: Bruno Wolff III
Date:
Subject: Re: problem porting MySQL SQL to Postgres