Cannot exec SQL from Function node?

[bstin]

I'm a newbie, but have a basic question.

I have 3 nodes: Trigger -> Function -> Postgresql

The function node is simply creating a string "INSERT into Table1 (val) VALUES (123);"

I can see this on debug, but the Postgresql node never executes.

How can I get the Postgresql node to exec msg.payload query directly?

[bstin]

Sorry....I just realized I need to set msg.query not msg.payload.

Its working....