From: Jeff Eckermann <jeff_eckermann@yahoo.com>
To: Kenneth Gonsalves <lawgon@thenilgiris.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: comparing nulls
Date: Tue, 20 Jan 2004 07:53:41 -0800 (PST)
Message-ID: <20040120155341.70533.qmail@web20807.mail.yahoo.com> (raw)
In-Reply-To: <400D4933.3030007@incentre.net>
--- Guy Fraser <guy@incentre.net> wrote:
> Kenneth Gonsalves wrote:
>
> >On Tuesday 20 January 2004 19:26, Chris Bowlby
> wrote:
> >
> >
> >>Hi Ken,
> >>
> >> Under 7.3.x this option was removed, you need to
> test via:
> >>
> >> SELECT * from table where field IS NULL;
> >>
> >>
> >thanx - works in both 7.1 and 7.3 - why do these
> guys keep fooling around
> >with these thangs?
> >
> >
> Standards compliance :-)
You can get the old behaviour by setting
"transform_null_equals" to true in postgresql.conf.
I believe that this was originally added to add
compatibility with MS Access. But Access no longer
requires this, and the developers were not interested
in maintaining a non-spec-compliant behaviour. But
the postgresql.conf setting was retained for those who
have code that relies on that behaviour.
__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jeff_eckermann@yahoo.com, lawgon@thenilgiris.com
Subject: Re: comparing nulls
In-Reply-To: <20040120155341.70533.qmail@web20807.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox