Re: Make foo=null a warning by default. - Mailing list pgsql-hackers

From Fabien COELHO
Subject Re: Make foo=null a warning by default.
Date
Msg-id alpine.DEB.2.21.1807160950140.3767@lancre
Whole thread Raw
In response to Re: Make foo=null a warning by default.  (Heikki Linnakangas <hlinnaka@iki.fi>)
List pgsql-hackers
Hello Heikki,

> The use case for transform_null_equals='warn' that I see is to wean off an 
> application that uses transform_null_equals='on', to find all the queries 
> that rely on it. But I'm not too excited about that either. The documented 
> case for using transform_null_equals='on' is compatibility with Microsoft 
> Access, and this wouldn't help with that. Besides, it's easy enough to grep 
> the application or the server log for " = NULL", to find all such queries.

I'm in favor in having this feature, even if off by default, because I 
could enable it and it would help my students when learning SQL in 
interactive sessions, where "grep '= *NULL'" cannot be issued.

-- 
Fabien.


pgsql-hackers by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: Make foo=null a warning by default.
Next
From: Phil Florent
Date:
Subject: RE: Internal error XX000 with enable_partition_pruning=on, pg 11beta1 on Debian