# PostgreSQL node - Using array(\['something'\]) duplicates the output

**URL:** <https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373>\
**Category:** Questions\
**Tags:** node\
**Created:** [March 28, 2024, 2:38pm UTC](https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373 "2024-03-28T14:38:51Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![theo](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/theo/32/41476_2.png) [@theo](https://community.n8n.io/u/theo)\
**Post date:** [March 28, 2024, 2:38pm UTC](https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373/1 "2024-03-28T14:38:51Z")

</div>

## Problem:

In a PostgreSQL node, writing `array(['something'])` duplicates what’s in parenthesis:

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/7/3/7355ba120d765856de5359340accfd18dccf94e4.png)

- **n8n version:** 1.33.1
- self-hosted mode on aws with Fargate (docker)
- using RDS Postgres and EFS for storing n8n data

---

<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:** [March 28, 2024, 2:38pm UTC](https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373/2 "2024-03-28T14:38:52Z")

</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:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\
**Post date:** [April 4, 2024, 1:00pm UTC](https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373/3 "2024-04-04T13:00:24Z")

</div>

Hey @theo,

I have taken a look and I was able to reproduce the UI issue, It looks like it is only cosmetic though and doesn’t send the duplicated value. I also checked your query directly against a postgres database and got the same syntax error, Looking at the postgres docs the correct query would be `select array['ele1_']` which does result in the same display issue but will send the correct query to the database.

I have created `NODE-1286` as the internal dev ticket to get the UI issue fixed in the future, Let me know if you have any questions on this.

---

<div class="post-metadata">

**Author:** ![theo](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/theo/32/41476_2.png) [@theo](https://community.n8n.io/u/theo)\
**Post date:** [April 4, 2024, 1:35pm UTC](https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373/4 "2024-04-04T13:35:21Z")

</div>

Hey @Jon

Thank you a lot, it helped to fix this! 🙏

---

<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:** [April 11, 2024, 1:35pm UTC](https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373/5 "2024-04-11T13:35:26Z")

</div>

Closed on April 11, 2024, 1:35pm UTC

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

---

<div class="post-metadata">

**Author:** ![jan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jan/32/9_2.png) [@jan](https://community.n8n.io/u/jan)\
**Post date:** [April 24, 2024, 1:38pm UTC](https://community.n8n.io/t/postgresql-node-using-array-something-duplicates-the-output/43373/6 "2024-04-24T13:38:18Z")

</div>

New version [`n8n@1.39.0`](https://github.com/n8n-io/n8n/releases/tag/n8n%401.39.0) got released which includes the [GitHub PR 9129](https://github.com/n8n-io/n8n/pull/9129).
