failed to execute the psql case statement which has the function call.

From: Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: failed to execute the psql case statement which has the function call.
Date: 2022-04-05 08:00:14
Message-ID: CALXkTpzzBp7+NjXt5QptMsefJGgnnxoE2mQJKHR0-ucyZaUd+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Regards,
Nikhil Ingale

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message hubert depesz lubaczewski 2022-04-05 09:07:21 Re: failed to execute the psql case statement which has the function call.
Previous Message Scott Ribe 2022-04-01 20:43:26 Re: WAL & ZFS