Postgres Extended icon

Postgres Extended

Extended Postgres operations to complement the built-in Postgres node

Actions7

Check → Row Does Not Exist

AI-generated

Summary

Check whether no rows exist in a specified table within a schema that satisfy given filter conditions and output only the input items for which no matching row is found.

Inputs

  • Schema (required) — The database schema to check within, specified by name or selected from a list.
  • Table (required) — The table to check for matching rows, specified by name or selected from a list.
  • Must Match — Match condition type: either all specified conditions must be satisfied or any one of them.
  • Conditions (required) — One or more column/operator/value conditions used to filter rows for matching.

Output shape

a filtered list of input items

For each input item, evaluates the conditions on the specified table and outputs only those items where no matching row exists. Conditions must be set, otherwise execution throws an error. Each output item is paired with its respective input item index.

Links

Discussion