From: | Mark Stosberg <mark(at)summersault(dot)com> |
---|---|
To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: behavior of ' = NULL' vs. MySQL vs. Standards |
Date: | 2001-06-07 14:40:40 |
Message-ID: | 3B1F9266.EEE2D1F0@summersault.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-sql |
Stephan Szabo wrote:
>
> On Wed, 6 Jun 2001, Tom Lane wrote:
>
> > Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> > > Yes, column = NULL should *never* return true according to the spec (it
> > > should always return NULL in fact as stated). The reason for breaking
> > > with the spec is AFAIK to work with broken microsoft clients that seem to
> > > think that =NULL is a meaningful test and generate queries using that.
> I'd rather have the default be the spec correct behavior
> and let people configure their server to follow the misinterpretation.
I like that idea as well. Someone like me who didn't know that this
feature was in there for M$ could have assumed it _was_ standard
behavior, and started using it as a habit. Then when I started porting
my code to another database, I'd have an extra surprise in for me. :)
Rather than being an option targeted at just this piece of grammer,
perhaps it could a piece of a potentially larger option of "stricter
standards compliance." I realize there are a number of useful extensions
to the SQL standard in Postgres (which I like and use.), but it seems
like there would be uses for minimizing non-standard behavior, as well.
Thank you all for your contributions to Postgres-- I use it everyday. :)
-mark
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2001-06-07 14:43:50 | Re: Any time estimates for 7.1.2 RPM's ? |
Previous Message | Peter Eisentraut | 2001-06-07 14:40:08 | Re: elog(NOIND)? |
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Stosberg | 2001-06-07 14:45:58 | Re: About table column names. |
Previous Message | Thomas Lockhart | 2001-06-07 13:41:32 | Re: behavior of ' = NULL' vs. MySQL vs. Standards |