Thanks folks, issue got resolved.
On Tue, Apr 5, 2022 at 7:40 PM Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
"David G. Johnston" <david.g.johnston@xxxxxxxxx> 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
