Use single quotes ('attribute') for variable in function.
On Tue, Apr 5, 2022 at 7:04 PM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:
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.
