# Postgres use array as a query parameters

**URL:** <https://community.n8n.io/t/postgres-use-array-as-a-query-parameters/35818>\
**Category:** Questions\
**Tags:** postgres\
**Created:** [January 24, 2024, 7:08pm UTC](https://community.n8n.io/t/postgres-use-array-as-a-query-parameters/35818 "2024-01-24T19:08:41Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Valdri](https://avatars.discourse-cdn.com/v4/letter/v/e47774/32.png) [@Valdri](https://community.n8n.io/u/Valdri)\
**Post date:** [January 24, 2024, 7:08pm UTC](https://community.n8n.io/t/postgres-use-array-as-a-query-parameters/35818/1 "2024-01-24T19:08:41Z")

</div>

I’m making a sql query:

```auto
SELECT *
FROM order_items
WHERE order_id = $1 AND id IN (1120000532, 1120000533, 1120000534)

```

I want to use array from previous node output as a sql query parameters

```auto
[
  {
    "order_product_id": [
      "1120000532",
      "1120000533",
      "1120000534"
    ]
  }
]

```

## Information on your n8n setup

- **n8n version:** 1.22.6,

---

<div class="post-metadata">

**Author:** ![n8n](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/n8n/32/196425_2.png) [@n8n](https://community.n8n.io/u/n8n)\
**Post date:** [January 24, 2024, 7:08pm UTC](https://community.n8n.io/t/postgres-use-array-as-a-query-parameters/35818/2 "2024-01-24T19:08:42Z")

</div>

It looks like your topic is missing some important information. Could you provide the following if applicable.

- **n8n version:**
- **Database (default: SQLite):**
- **n8n EXECUTIONS\_PROCESS setting (default: own, main):**
- **Running n8n via (Docker, npm, n8n cloud, desktop app):**
- **Operating system:**

---

<div class="post-metadata">

**Author:** ![BramKn](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/bramkn/32/11894_2.png) [@BramKn](https://community.n8n.io/u/BramKn)\
**Post date:** [January 24, 2024, 8:23pm UTC](https://community.n8n.io/t/postgres-use-array-as-a-query-parameters/35818/3 "2024-01-24T20:23:08Z")

</div>

Hi @Valdri

> {{ $json.order\_product\_id.join(‘,’) }}

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [January 31, 2024, 8:23pm UTC](https://community.n8n.io/t/postgres-use-array-as-a-query-parameters/35818/4 "2024-01-31T20:23:12Z")

</div>

Closed on January 31, 2024, 8:23pm UTC

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.