Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Postgresql syntax error while using params. #88

Open
BairDev opened this issue Sep 27, 2024 · 0 comments
Open

Postgresql syntax error while using params. #88

BairDev opened this issue Sep 27, 2024 · 0 comments

Comments

@BairDev
Copy link

BairDev commented Sep 27, 2024

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?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant