Re: BUG #18774: Not the required output of the query used in the function(delete_from_table1) in postgresql9.4
Alvaro Herrera <alvherre@alvh.no-ip.org>
From: Álvaro Herrera <alvherre@alvh.no-ip.org>
To: Rajni Bobal <rajnibobal@gmail.com>
Cc: Greg Sabino Mullane <htamfids@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2025-02-03T11:10:51Z
Lists: 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/