JSONB Functions don't exists on Postgres Select Query Node

[justin-salesduo]

Describe the problem/error/question

All JSONB Functions can't be used in Postgres Node.

What is the error message (if any)?

Please share your workflow/screenshots/recording

{
"nodes": [
{
"parameters": {
"operation": "executeQuery",
"query": "SELECT COUNT() AS total_emails\nFROM public."Emails"\nWHERE jsonb_path_exists(\n "relatedPeople",\n '$[] ? (@.personId == 277630 || @.personId == 287123)'\n )",
"options": {}
},
"type": "n8n-nodes-base.postgres",
"typeVersion": 2.5,
"position": [
600,
-80
],
"id": "fd93e7a9-623a-4920-aea9-d550788bcddb",
"name": "Email Check",
"executeOnce": false,
"alwaysOutputData": true,
"credentials": {
"postgres": {
"id": "ZKVM5ScWFBwiOSlj",
"name": "Supabase"
}
}
}
],
"connections": {
"Email Check": {
"main": [
[]
]
}
},
"pinData": {},
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "a37f54e31a8b521577eb91d3d2fba1ab570ba18f84dedc68099830c7f1341c93"
}
}

Share the output returned by the last node

{
"errorMessage": "function jsonb_path_exists(jsonb[], unknown) does not exist",
"errorDescription": "No function matches the given name and argument types. You might need to add explicit type casts.",
"errorDetails": {},
"n8nDetails": {
"nodeName": "Email Check",
"nodeType": "n8n-nodes-base.postgres",
"nodeVersion": 2.5,
"resource": "database",
"operation": "executeQuery",
"time": "1/19/2025, 8:38:43 AM",
"n8nVersion": "1.74.3 (Self Hosted)",
"binaryDataMode": "default",
"stackTrace": [
"NodeOperationError: function jsonb_path_exists(jsonb[], unknown) does not exist",
" at parsePostgresError (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/helpers/utils.js:102:12)",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/helpers/utils.js:205:31",
" at processTicksAndRejections (node:internal/process/task_queues:95:5)",
" at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/actions/database/executeQuery.operation.js:106:12)",
" at ExecuteContext.router (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/actions/router.js:59:26)",
" at ExecuteContext.execute (/usr/local/lib/node_modules/n8n/node_modules/n8n-nodes-base/dist/nodes/Postgres/v2/PostgresV2.node.js:16:16)",
" at WorkflowExecute.runNode (/usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:632:19)",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:872:51",
" at /usr/local/lib/node_modules/n8n/node_modules/n8n-core/dist/WorkflowExecute.js:1206:20"
]
}
}

Debug info

core

• n8nVersion: 1.74.3
• platform: npm
• nodeJsVersion: 20.18.1
• database: sqlite
• executionMode: regular
• concurrency: -1
• license: enterprise (production)

storage

• success: all
• error: all
• progress: false
• manual: true
• binaryMode: memory

pruning

• enabled: true
• maxAge: 168 hours
• maxCount: 10000 executions

client

• userAgent: mozilla/5.0 (macintosh; intel mac os x 10_15_7) applewebkit/537.36 (khtml, like gecko) chrome/132.0.0.0 safari/537.36
• isTouchDevice: false

Generated at: 2025-01-18T12:04:41.548Z}

[Joffcom]

Hey @justin-salesduo,

We have created an internal ticket to look into this which we will be tracking as "N8N-8159"