On Tuesday, April 5, 2022, Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com> 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.