Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4 - Mailing list pgsql-bugs

On 2025-Feb-03, Rajni Bobal wrote:

> Please clarify the use of %I will not be substituted by the string literal
> 'colname' rather its value will be substituted dynamically.

Yes, it is expanded dynamically to the _value_ of the variable
colname, not to the literal 'colname'.  If you wanted to expand a
string literal there, you would use something like

SELECT format('some text .. %I ... more', 'colname');

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/