Postgres Extended icon

Postgres Extended

Extended Postgres operations to complement the built-in Postgres node

Actions7

Check → Row Exists

AI-generated

Summary

Check whether at least one row exists in the specified Postgres table that matches the given conditions and output only the input items for which such matching rows exist.

Inputs

  • Schema (required) — The schema containing the table to check.
  • Table (required) — The table to check for matching rows.
  • Must Match — Controls whether all conditions must be met ('All Conditions') or just any one condition ('Any Condition') for a row to be considered matching. Defaults to 'All Conditions'.
  • Conditions (required) — List of column/operator/value criteria to match rows. At least one condition must be provided. Operators include Equal, Not Equal, Like, Greater Than, Less Than, Greater Than Or Equal, Less Than Or Equal, Is Null, and Is Not Null.

Output shape

A list of input items filtered to only those for which at least one matching row exists in the target table.

Evaluates each input item independently using its corresponding parameters and conditions. If a matching row is found in the database for an item, that item is passed through. If no match is found, the item is not output. Errors in individual items can optionally be caught and output as error objects when 'Continue on Fail' is enabled.

Links

Discussion