Re: problem porting MySQL SQL to Postgres
От | Paul Thomas |
---|---|
Тема | Re: problem porting MySQL SQL to Postgres |
Дата | |
Msg-id | 20040418202447.A16735@bacon обсуждение исходный текст |
Ответ на | Re: problem porting MySQL SQL to Postgres (Markus Bertheau <twanger@bluetwanger.de>) |
Ответы |
Re: problem porting MySQL SQL to Postgres
|
Список | pgsql-sql |
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 по дате отправления: