D. Dante Lorenso wrote:
I'm looking for an operator that will compare NULL with NULL and
evaluate as TRUE.
I have a BIGINT column which might contain NULL values. I want to pass
a value to compare with that column in my WHERE clause. If the value
I'm comparing is 0, I want it to match the NULL values. Here is a
sample query that I currently use:
SELECT *
FROM mytable
WHERE (col IS NULL AND NULLIF(?, 0) IS NULL) OR col = ?;
The '?' placeholders used in the query will receive the same value which
might be any one of the following: NULL, 0, 1, 2, 3, etc.
What I'd really like is an operator that will compare NULL with NULL and
evaluate as TRUE. Does that exist?
Is this the answer?
SELECT *
FROM mytable
WHERE col IS NOT DISTINCT FROM NULLIF(?, 0);
-- Dante
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
