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

Questions
1

Problem:

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

image
image883×504 20.2 KB

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

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:
3

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.

4

Hey @Jon

Thank you a lot, it helped to fix this! :pray:

6

New version n8n@1.39.0 got released which includes the GitHub PR 9129.