Name: n8n秀社区
Availability: InStock

SELECT color, shirt_size FROM shirts WHERE shirt_size IN ('small', 'medium', 'large');

Set the Operation to Execute Query.
In Options, select Query Parameters.
Use an expression to select an array from the input data. For example, {{ $json.input_shirt_sizes }}.
In the Query parameter, write your query with the IN construct with an empty set of parentheses. For example:
```
SELECT color, shirt_size FROM shirts WHERE shirt_size IN ();
```
Inside of the IN parentheses, use an expression to dynamically create index-based placeholders (like $1, $2, and $3) for the number of items in your query parameter array. You can do this by increasing each array index by one since the placeholder variables are 1 indexed:
```
SELECT color, shirt_size FROM shirts WHERE
```

Postgres node common issues

Postgres node common issues

Dynamically populate SQL `IN` groups with parameters