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

Thanks folks, issue got resolved.

On Tue, Apr 5, 2022 at 7:40 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)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
>