Postgres Pro
Downloads
Home   >   mailing lists

Re: failed to execute the psql case statement which has the function call. - Mailing list pgsql-admin

From sagar jadhav
Subject Re: failed to execute the psql case statement which has the function call.
Date
Msg-id CACPo9Dp=aq9cgn2ssyC6YFHsJ5Wbq1ZbRYNDJWeujerQa3TLVA@mail.gmail.com
Whole thread Raw
In response to Re: failed to execute the psql case statement which has the function call.  ("David G. Johnston" <david.g.johnston@gmail.com>)
Responses Re: failed to execute the psql case statement which has the function call.
List pgsql-admin
Tree view
Use single quotes ('attribute') for variable in function.



On Tue, Apr 5, 2022 at 7:04 PM David G. Johnston <david.g.johnston@gmail.com> wrote:


On Tuesday, April 5, 2022, Nikhil Ingale <niks.bgm@gmail.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.
 

pgsql-admin by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: failed to execute the psql case statement which has the function call.
Next
From: "David G. Johnston"
Date:
Subject: Re: failed to execute the psql case statement which has the function call.