Обсуждение: failed to execute the psql case statement which has the function call.

On Tue, Apr 05, 2022 at 01:30:14PM +0530, Nikhil Ingale 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.
> 
> ERROR:  column "attributes" does not exist
> LINE 1: ... WHEN status_code = 0 THEN CASE WHEN bmask(attributes...
> 
> Need help to resolve this problem.

Well, we need to see the function. Otherwise all *I* can tell is: well,
you have to find source of the problem, and fix it.

Best regards,

depesz

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.

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> But the error fragment shown suggests that the query shouldn't be expecting
> a column name (contrary to my earlier point), so we are back to having to
> see the entire function definition (or a reproducible example) to provide
> an answer.  Spelling typo comes to mind.

I'm wondering if there's an actual function involved at all.
Maybe the OP is just writing this in a psql script and wanting
to substitute a psql variable.  In that case something like
:'variable' might be the solution.

Bottom line is the same though: we need to see a lot more context
than we've been shown.

            regards, tom lane