Re: FW: "=" operator vs. "IS"

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Rich Hall <rhall(at)micropat(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: FW: "=" operator vs. "IS"
Date: 2004-06-29 17:37:21
Message-ID: 87wu1qxo32.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Rich Hall <rhall(at)micropat(dot)com> writes:

> "(anything) = NULL" is always Null, this cannot be what the coder intended.

I often have such things in my SQL. Consider what happens when you have SQL
constructed dynamically. Or more frequently, consider that many drivers still
don't use the new binary placeholder syntax and emulate it by putting the
parameters directly into the SQL.

--
greg

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Stephan Szabo 2004-06-29 17:46:03 Re: FW: "=" operator vs. "IS"
Previous Message Greg Stark 2004-06-29 17:33:23 Re: FW: "=" operator vs. "IS"