node-red-contrib-postgresql icon indicating copy to clipboard operation
node-red-contrib-postgresql copied to clipboard

Postgresql syntax error while using params.

Open BairDev opened this issue 1 year ago • 0 comments

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?

BairDev avatar Sep 27 '24 15:09 BairDev