Re: [GENERAL] avoid replace of column with variable in pgsql function

2008-11-16 Thread Tom Lane
Gerhard Heift <[EMAIL PROTECTED]> writes: > I have a function with an out variable in which I have an INSERT > statement with the same name as column. Is it possible to avoid the > replacement? No, but you could rename the variable. If you don't want to change the externally exposed name, try usi

[GENERAL] avoid replace of column with variable in pgsql function

2008-11-16 Thread Gerhard Heift
Hello, I have a function with an out variable in which I have an INSERT statement with the same name as column. Is it possible to avoid the replacement? Its something like this: CREATE FUNCTION insert_foo(IN bar integer, OUT id integer) AS $BODY$ BEGIN INSERT INTO t1 (id, value) VALUES (bar, b