On Tuesday, April 5, 2022, Nikhil Ingale <niks.bgm@xxxxxxxxx> wrote:
Hi All,I've a case statement where I'm calling the user defined postgres function and failed to execute the same. Because it's assuming the variable passed inside the function as a column for the table.
You cannot use variables for identifiers in raw sql. If you need to do that you must use dynamic sql - build a string using format and execute it.
David J.
