"Bui, Michelle P" <michelle.p.bui@xxxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
