Re: SQL works but same function is confused

"Bui, Michelle P" <michelle(dot)p(dot)bui(at)boeing(dot)com> writes:
> I have this query that when executed as a SQL statement, it works perfect!

OK ...

> I used <<block>> before Declare section and try using block.v_status but
> this is not allowed (has syntax error).

That should work (in the sense of not getting a syntax error), but since
you've not shown us exactly what you wrote, it's impossible to say what
you did wrong. However, that's mostly beside the point, because ...

> When I use #variable_conflict use_variable, there is no error anymore, but the resulted Status field is null. Seemed like Postgresql does not assign the v_status as we wish.

According to the above, the behavior you want is use_column. Why are you
trying to get it to use the variable when that's not what you want?

regards, tom lane