IN Clause with NULL or IS NULL

by

An in statement will be parsed identically to field=val1 or field=val2 or field=val3. Putting a null in there will boil down to field=null which won’t work.

(Comment by Marc B)

I would do this for clairity

SELECT *
FROM tbl_name
WHERE 
(id_field IN ('value1', 'value2', 'value3') OR id_field IS NULL)

More Related Contents:

  1. Select rows which are not present in other table
  2. Sort by column ASC, but NULL values first?
  3. Create unique constraint with null columns
  4. Best way to check for “empty or null value”
  5. Sorting null values after all others, except special
  6. Sort NULL values to the end of a table
  7. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  8. Combine two columns and add into one new column
  9. Check if NULL exists in Postgres array
  10. Does PostgreSQL support “accent insensitive” collations?
  11. PostgreSQL: running count of rows for a query ‘by minute’
  12. IN vs ANY operator in PostgreSQL
  13. Escaping keyword-like column names in Postgres
  14. GROUP BY + CASE statement
  15. Split column into multiple rows in Postgres
  16. Perform this hours of operation query in PostgreSQL
  17. Getting date list in a range in PostgreSQL
  18. Postgres Dynamic Query Function
  19. How do I delete a fixed number of rows with sorting in PostgreSQL?
  20. What is the equivalent PostgreSQL syntax to Oracle’s CONNECT BY … START WITH?
  21. How to use an ALIAS in a PostgreSQL ORDER BY clause?
  22. Error: Column does not exist
  23. DROP FUNCTION without knowing the number/type of parameters?
  24. Multiple array_agg() calls in a single query
  25. PostgreSQL does not accept column alias in WHERE clause
  26. Check whether string is a date Postgresql
  27. Counting the number of occurrences of a substring within a string in PostgreSQL
  28. Return rows from INSERT with ON CONFLICT without needing to update
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. Fetch records that are non zero after the decimal point in PostgreSQL

Leave a Comment