Postgresql syntax error while using params.

Open
#88 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
25/100
Issue type
Bug
Clarity
Needs clarification
Activity status
Stale
Tech stack
postgresql
Domain
databases

Research direction

The issue names the PostgreSQL node and a Function node parameter array, but no repository file or test. Start by reproducing the shown function call and tracing how the node handles parameterized PostgreSQL queries; done would mean identifying whether the node or SQL input causes the syntax error and adding a regression test or documented resolution.

Written by the indexing model from the issue text.

Description

Suppose a parameter array like

return {payload: dataObj, /* which also contains the data */ params: [
    null,
    'test_identifier,
    2.0,
    '2024-09-26 14:40:00+2'
]};

(Used in a function node.)

We also have defined this postgresql function

CREATE OR REPLACE FUNCTION handle_val(
    error TEXT, -- might be problem, error is usually is null?
    tableId TEXT,
    value NUMERIC,
    vDate TIMESTAMP WITH TIME ZONE)

RETURNS void LANGUAGE plpgsql AS 
$body3$

  -- do stuff, has been tested!

$body3$;

Then I call the function in the postgresql node

Insert-Value

But I am getting an error:

"error: Syntax error at »-«"

I don't have any clue, what its reason can be.

What am I doing wrong?
Dominant language
HTML
Stars
38
Forks
12
Avg merge
4h 1m
Merged PRs (30d)
2

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from alexandrainst/node-red-contrib-postgresql

All issues in alexandrainst/node-red-contrib-postgresql

Similar issues

More Databases issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.