BruceFletcher / node-red-contrib-postgres-multi

Multi-query variant of node-red-contrib-postgres
Apache License 2.0
5 stars 11 forks source link

Wiring output of an INSERT operation. #2

Closed chainhead closed 6 years ago

chainhead commented 6 years ago

It seems that, after an INSERT, there is no message on the output node. Therefore, as per Node-RED design, the flow stops. Whereas, I want to do few more operations after the INSERT is successful. How can we trigger next node after an INSERT?

chainhead commented 6 years ago

Using the RETURNING clause in the INSERT statement will generate an output for the next node to take over.