Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards

From: Tom Ivar Helbekkmo <tih(at)kpnQwest(dot)no>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, Mark Stosberg <mark(at)summersault(dot)com>, pgsql-sql(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards
Date: 2001-06-07 19:17:40
Message-ID: 861yownlpn.fsf@athene.i.eunet.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> A compromise answer might be to offer a SET variable that selects the
> Microsoft-compatible misimplementation. Would that fly?

I'd say that's the best way to handle stuff like this. If you
implement something that breaks the standard, to be compatible with
arrogant programmers at Microsoft who feel that they are above such
things, you're encouraging users to develop bad habits. Better to
make them go "SET MICROSOFT BUG COMPATIBILITY ON" first.

To see the effect of leniency in re standards, just try to browse
around the web with a browser that rejects incorrect HTML! :-)

-tih
--
The basic difference is this: hackers build things, crackers break them.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Rachit Siamwalla 2001-06-07 19:29:00 RE: Any time estimates for 7.1.2 RPM's ?
Previous Message mlw 2001-06-07 18:36:59 Re: 7.2 items

Browse pgsql-sql by date

  From Date Subject
Next Message Mike Mascari 2001-06-07 19:36:20 RE: [HACKERS] Re: behavior of ' = NULL' vs. MySQL vs. Standards
Previous Message Gerald Gutierrez 2001-06-07 19:17:14 Re: Getting row with id=max(id)