Postgres Is Null condition should honor false for Is Not Null

Feature Requests Nodes
1

Describe the problem/error/question

It’s great that the Postgres Select module has a condition for “Is Null”. But what about “Is Not Null”? It does not seem to work to try to match to “{{ false }}” to find items that are not null.

Please share your workflow

In this example, the top module (using Select and conditions) returns no rows. The bottom module (using a SQL query) returns 9 rows.

You’ll need to create a dummy table to test this, but it should be easy to replicate.

Information on your n8n setup

  • n8n version: 1.36.2
  • Database (default: SQLite): Postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main): depricated
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Elastic Container
  • Operating system: Docker
2

Hi @Lee_S,
When IS NULL is set as false (which doesn’t typically happen in SQL as IS NULL is not a boolean but a state check), n8n would treat it as IS NULL which I do agree is a little confusing. I’ll also ask internally about an option to add ‘IS NOT NULL’, thanks for letting us know!

3

New version [email protected] got released which includes the GitHub PR 9241.