Postgres Pro
Downloads
Home   >   mailing lists

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

From hubert depesz lubaczewski
Subject Re: failed to execute the psql case statement which has the function call.
Date
Msg-id 20220405090721.GA4757@depesz.com
Whole thread Raw
In response to failed to execute the psql case statement which has the function call.  (Nikhil Ingale <niks.bgm@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: Nikhil Ingale
Date:
Subject: 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.