Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.


In response to

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group