On Thu, 20 Dec 2001, Bruno Wolff III wrote:
> On Thu, Dec 20, 2001 at 04:24:33PM -0800, > "Bob Smith, Hammett & Edison, Inc." <[EMAIL PROTECTED]> wrote: > > See example below of using NULL values with type DATE. It behaves > > strangely in expressions, "(x <> null)" gives an entirely different > > result than "not(x = null)". Is this intended behavior, if so, why? > > If not, is this a bug? > > There is a hack which will be off by default in 7.2 that changes > 'x = null' into 'x is null' for compatibility with sqlserver. As a note, I think it was actually for some feature of Access. :) ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
