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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Apr 5, 2022 at 6:47 AM sagar jadhav <sagarjdhv5@xxxxxxxxx> wrote:
Use single quotes ('attribute') for variable in function.

That just produces the literal variable - it doesn't cause a substitution of the variable's value into the query.  And if the position of usage does need a column identifier it still will produce a syntax error.

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.

David J.


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux