Horton

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

David G. Johnston <david.g.johnston@gmail.com>

View thread
From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Rajni Bobal <rajnibobal@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Vik Fearing <vik@postgresfriends.org>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Date: 2025-01-23T14:24:47Z
Lists: pgsql-bugs 
On Thursday, January 23, 2025, Rajni Bobal <rajnibobal@gmail.com> wrote:

> Hello SIr,
> Please clarify about why $1 is not been replaced by 'colname' in delete_from_table2
> function.
>

It has been replace with the string literal value ‘colname’, not a column
reference identifier “colname”.  You cannot use positional parameters to
supply identifiers.  Structure must be known at parse time.

David J.