Code Inspection: Misleading references
Reports ambiguous references in SQL code.
For example, when a name refer to both a table column and a routine parameter. The execution of such code might lead to errors or unexpected results due to counter-intuitive resolution logic. Usually, names with a more local scope have higher priority.
In PostgreSQL, you can use the
#variable_conflict directives to explicitly specify a correct reference. For example, use
#variable_conflict use_column to refer to a column name, or
#variable_conflict use_variable to refer to a parameter.
Suppress an inspection in the editor
Place the caret at the highlighted line and press Alt+Enter or click .
Click the arrow next to the inspection you want to suppress and select the necessary suppress action.